‎2022 Jul 14 3:06 AM
Hi Experts, I need some advice on accounting for owner allocation set up. I am working for a utility retailer and we are offering a package for Embedded network customers to do billing and collections for tenants on behalf of the owner.
One connection object is linked to all the premises of the Embedded network through ES51 and each premise is assigned to a tenant BP, but the premise owner is the BP of Embedded network owner.
Data model:
Considering, 1 Embedded network owner = EMB_OWNER
Multiple tenants, EMB_TEN
WP = Metering service provider of the main master meter for the whole Embedded network
SPTL = Embedded metering service provider
CMM = Check master meter of Embedded network
CAR = Common area
EMB_OWNER_BP
WP_CA, WP_INST
SPTL_CMM_CA, SPTL_CMM_INST
SPTL_CAR_CA, SPTL_CAR_INST
EMB_TENANT_BP1
SPTL_TEN_CA1, SPTL_TEN_INST1
EMB_TENANT_BP2
SPTL_TEN_CA2, SPTL_TEN_INST2
EMB_TENANT_BPn
SPTL_TEN_CAn, SPTL_TEN_INSTn
Owner WP_CA is already billed based on reading provided by WP which is accounted as our revenue.
Now, we are planning to post invoices at tenant CAs based on reads provided by SPTL. Send the tenants these invoices and collect payments from them. If they are not able to pay, debt will be transferred to WP_CA of the owner.
Does SAP provide a standard solution for this kind of set up? We tried posting statistical invoices at tenant, but that is not allowed (account determination error).
We cannot record revenues for tenant invoices in our revenue GLs and we may have to refund the owner for excess collections made in case, prices for tenants are more than prices charged for main meter (WP_INST) billing.
Please share your ideas and let me know if any questions.