Customer posting group database

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I am currently trying to update the customer posting group with new accounts. What do the invoice rounding column and the Debit current rnding account and credit current rnding account, debit and credit rounding accounts usually hold? What is the difference between the two accounts?

Finally, if certain columns are not used can I leave them blank?

*This post is locked for comments

All responses (3)

Answers (1)

mmv 11,465 on at

Like (0)

Report

RE: Customer posting group database

Hi,

You don't need to specify the table number, it's already been designed in the system to pick up the Customer Posting Group while making entries in the system.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Customer posting group database

Thank you, how do i tell what table number customer group is or any other posting group?
Verified answer

mmv 11,465 on at

Like (0)

Report

RE: Customer posting group database

Hi,

Yes, you may leave those unused accounts blank.

You may check the below for Debit rounding and credit rounding:-

Rounding differences occur when there's multiple lines of transactions.

Following below scenario:

1) You are selling 6 different items with individual price

2) Your country accounting standards is 2 decimal places

3) Assuming Home Currency (Local) is SGD

4) The Exchange Rate you using is: 1 USD = 1.22589 SGD

6) The above value going to your Customer Control A/C and sub ledger will be total * exchange rate

7) From below, you will find there's a "0.01" difference. which will go to the Credit Rounding Account.

Rate: 1.22589

USD SGD

Item 01 1.05 1.29

Item 02 5.26 6.45

Item 03 3.28 4.02

Item 04 15.25 18.69

Item 05 16.87 20.68

Item 06 11.26 13.8

52.97 64.93

Customer 52.97 64.94