change customer posting group

DRAM

Hi,

we would like to allow users to change customer posting group when entering orders. It has to do with spcial type of invoices. It is no problem to put the field on the order form, but when the order is invoiced the system takes the customer posting group from the customer record and not from the Order head. Is there an easy way to change that so that the invoice taks the right code (one from Sales Header).

Regards

Draggan

andrejsm

There are some more problems with this solution. You need the same corrections in Adjust Exchange Rates... batch job.

And you will need to rewrite standart Navision reports - posting group is usually used for filtering purposes. But in some reports you can not just open "Customer Legder Entry" and filter by group.

Users don't care about posting group when they receive payment from customer, but with this modification they will need to think about it

Everything is not so bad, but it's not piece of cake.

kriki

DRAM wrote:

Hi,

we would like to allow users to change customer posting group when entering orders. It has to do with spcial type of invoices. It is no problem to put the field on the order form, but when the order is invoiced the system takes the customer posting group from the customer record and not from the Order head. Is there an easy way to change that so that the invoice taks the right code (one from Sales Header).

Regards

Draggan

Strange, I checked the code and the code is copied from the customer to the header. From the header it is copied to the lines. And in the posting routine, these are used for posting.
Maybe your country-version has changed this?

DRAM

Maybe I havn't expressed myself clearly. I am talking about Customer Posting group, the one that determine which G/L accoun for Acc.Receivebles shell be used on invoicing an order. Generaly a customer has one CPG, but for some purposes we need to change that account for certain orders and invoices.

The only purpose this code should have is to read which accounts to use when posting an invoice. There is no reason for any report to follow customer posting group because it is better to use acctua account.

I have also checked Sales line table and there is no field for Customer Posting Group. Maybe I've missed it.

I hope you can help me out.

Regards

Draggan

Rodriguez

Hi,

Actually, I'd be quite surprised if you said the posted CPG/GL Account was still the one taken from the customer card. Did you confirm that your users did change the CPG on the Sales Order Header? Coz, I think NAV would surely post into the correct G/L account (according to the CPG stated on the Order Header/transaction).

Regards,
Rodriguez

ssingla

Customer Posting group is used for defining the G/L account for the customer balance. As we have the total amount for a particular customer grouped under one customer code, the total balance for that particular customer should also be grouped in One G/L account. Else there will be diffrence is the Customer balance and other reports as they group the reports on Posting Group (Available on Customer Card) - Customer No..

You can/should use Dimensions to identify/report the balance under diffrent groups.

DRAM

OK guys, this is what we have done:

we have Customer Posting Group STD with Acc. Rec. 1510 and Customer Posting Group SPEC with Acc. Rec. 1615

- edited form 42 sales order end put Customer Posting Group on it.
- edited table 36 Sales Header and made the field Customer Posting Group editable.
- entered an order for a customer with CPG STD on the customer card.
- changed CPG to SPEC on the order header.
- posted the invoice.
- the posted invoice still has SPEC as CPG when we look at it with ctrl+F8 but on the journal it is posted to account 1510, i. e. account from CPG STD.

Try to repeat the procedure and please let me know if you do not come up with the same result or with a suggestion to how to solve this.

Regards

Draggan

Alex_Chow

Yep, you're right. The customer posting group is taken from the customer card instead of the sales order header.

You'll need to change this in the posting routine in codeunit 80. Specifically, you'll need to fill in the "Posting Group" field in the general journal table with whatever's on the sales header. It's a simple tweak.

Good luck!

ssingla

This is not it.

Think when the payment of the invoice comes, the possible scenarios :

1. You apply the payment to the invoice : The CPG will be picked from the Customer card, but you can modify by writing code that it picks/uses the CPG of the posted invoice. Everything fine but what if the invoice and payment application entry is reversed.

2. You do not apply payment to the invoice it will be posted in the G/L account using CPG on Customer card, and later on you wanna apply it to invoice having different CPG than the customer card. You will have tpo write a routine to pass the adjustment entry in the G/L.

I think this customization will throw a lot of bugs.

beware of them

pri_1_ranjan

that can be easily done thru customization.. since the changing of the customer posting group only effects the gl account to which it is posted .. i do not see any problem in that

pri_1_ranjan

that can be easily done thru customization.. since the changing of the customer posting group only effects the gl account to which it is posted .. i do not see any problem in that

ssingla

Let me explain by example :

CPG on Customer Card : STD : G/l Account 1510
Modified CPG on Invoice : SPEC : G/l Account 1615

Invoice Of $100 posted with CPG - "SPEC" resulting in the following transactions in G/L Entry (Table 17) :

Receivable Account 1615 Debit $100
Sales Account xyz Credit $100

On payment of the invoice the default transaction will be :

Bank Account abc Debit $100
Receivable Account 1510 Credit $100 (Because it will pick the CPG on the Customer Card).

Though the Customer Ledger balance will have zero balance the G.L reconciliation account will have debit and credit balance of $100 inn 2 accounts and this will not be approved by any auditor or finance department.

To solve the scenario/problem you will then have to modify the CPG on the payment journal line as the same is mentioned on the applied invoice.
But think if no invoice is applied or application entry is reversed etc.....

ssingla

In Navision or any ERP customer balance is represented in only 1 control account in G/L. Navision is not Tally which can have this. It is only the clarifications/consultancy to the client which can reject the requirement as this can bring lots of reconcilliation issues.

Alex_Chow

ssingla wrote:

This is not it.

Think when the payment of the invoice comes, the possible scenarios :

1. You apply the payment to the invoice : The CPG will be picked from the Customer card, but you can modify by writing code that it picks/uses the CPG of the posted invoice. Everything fine but what if the invoice and payment application entry is reversed.

2. You do not apply payment to the invoice it will be posted in the G/L account using CPG on Customer card, and later on you wanna apply it to invoice having different CPG than the customer card. You will have tpo write a routine to pass the adjustment entry in the G/L.

I think this customization will throw a lot of bugs.

beware of them

Yep, you're absolutely right!

This problem will also compound if you have one check that pays multiple invoices with different customer posting groups.

If this is an absolute requirement, one way to resolve this is to actually change the posting routine so the payments will use the customer posting group on the source document instead of on the customer. Nonetheless, pain in the butt. #-o