SAP Posting for Control accounts

[Former Member]

Hi ,

Our legacy systems post entries to control accounts (which are use to check either posting that has been made by purchase invoice should reflect to be recharge). Recharge means that we have to charge customer for that.

In our case we receive invoice from supplier it goes to Purchase Ledger but it also goes to control accounts of that supplier that it has to be recharge. so we charge customer for that product. Please can you define me same process in sap B1.

Thanks

[Former Member]

Hi,

You can not post any entry direct to control account. if your supplier charge you for recharge, you will book it as AP invoice. So your purchase will book and Control account will also hit.

Same way you need to book AR invoice to your customer. It will hit your customer balance as well as control account. This is how SAP B1 built.

Supplier and Customers total balance reflect in Control account. All your Debtors are on asset side and all your creditors are on Liability side.

Regards,

Chintan

[Former Member]

Hi Chintal,

Can you explain this thing in more detail please.

Thank You

[Former Member]

Hi,

Once you charge you customer for recharge amount system will post that amount automatically to control account linked to that customer.

Same rule apply for purchasing cycle.

You can not post direct journal entry to control account. This is how SAP designed. So if you want to post anything to control account that must be go through normal sales or purchase cycle.

Regards,

Chintan

[Former Member]

Thanks Chintan,

We receive invoice from our suppliers for a service and then charge customer for that service which has been given. Our current legacy system uses control accounts to determine that a particular customer has been recharge for that service or not.

Example:

When we import Purchase Invoice it makes entry to debit side and then from there we can see which accounts has not been charged and then we if there is no entry on credit side then we charge customer and even the accounts.

we want to implement same process in SAP B1. Can you explain me from Purchase Invoice to Sales Invoice process in terms of postings.

Thank You

[Former Member]

Hi Jibran,

You can create sales order or invoice for customer and create raw level udfs (User Defined Field) Service used, to date and from date.

One basis of above udfs. You can write a alert query so system will send you pop up message on based of udf details.

Little bit of customization will solve your issue.

Regards,

Chintan

[Former Member]

We send consolidated invoice to our customer at the end of each month. Consolidated means one invoice for all services/products given to that customer for that month. So they all sits in control accounts to be recharged.

In terms of financials (G/L account) is there anything in SAP B1 that explains recharge.

Also is there any consolidated invoice functionality in SAP business one

[Former Member]

Hi Jibran,

You can create Single sales order for your customer and create multiple delivery documents. At last you can create just one invoice based on all deliveries during that month.

System will automatically debit customer as well as control account. On chart of account only control account balance will show. once that customer make payment to that invoice your customer will credit as well as your control account will credit.

Hope it helps.

Regards,

Chintan

[kothandaraman_nagarajan]

Hi,

Please raise service type invoice for Customer for recharge for that product.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

Please can you explain this in detail.

Thank You.