what is the affect of applying a receipt of a parent customer against a sales document of a child customer when both the customers are having different Receivables GL codes? does GP pass a journal entry for debiting and crediting the customers (differnet)

(0) Share

Report

Posted on by Saif Esmail

I have differenet divisions that supply the same customers, becuase of that I need to create different customer code for the same customer for each division so that i can utilize the credit limit and all other reports (by division). However, all the customers codes are related to a single parent code for each customer. We collect the payments and book it under the parent ID of each customer then we use the "Sales Document Apply" screen to do the matching. Now, the issue is, since each child and parent is having a different Receivables GL Code attached to it (each code for each division) I'm having an issue while applying as per the above scenario. My GL balance for the Receivables account is not matching the trial balance of every divison. I assume that GP should automatically takes care of the debit and the credit parts while doing the applying process and accordlying should pass journal entry to the General Ledger to reflect the cross GL accounts apply but unfortunately that is not happening. Does anyone have any idea on how to fixt this issue?

Regards,

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Community Member on at

Like (0)

Report

OK,

First thing first - Applying / unapplying in AR do nothing financially - its all when u post the Invoice and Cash reciepts - AR - Gl accounts will be pickp automatically Customer and Posting Account Setup.

if i can understand 1 - Parant Customer and

3 child which is your deffernet Departments

All having differ GL for AR and Sales

when Receiving Cash / Fund on Parant - One GL Accounts Cash/Checks Debit

and One GL Accounts AR Credit

applying will not distribute automatically to Applyied amount and related GL Acccounts.

the manual work around in Cash Recievings : Cash 100 USD if total - apply all the way it should be ,

print applying list , then on Cash Reciept entry ---> clik -- distribution -->

select all the child GL Accounts for Debit on Cash (different Department)

and Credit A/R as many required , keep the same distribution type as originated

Distribute Debit amount 100(in to As applied) usd to all 3- Child GL Accounts as you have applied

and similarly

Distribute credit amount 100 (in to As applied) usd to all 3- Child GL Accounts as you have applied

This will balance your GL and A/R and Cash Accounts if u want to be

### Now the difference Only we will have , if u are maintaining Chequebook Balance - that you have to reconcile , as one checkbook id only can be assign while creating receipts. you may can have dummy cheque book id.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

previous detail is for the Cash Reciepts not posted yet :

if Recipts posted and Related Genral Journal not posted u still can edit , if Genral Journal also Posted then you have to revese / enter a revers effect enty and Distribute accordingly before posting .

Was this reply helpful? Yes No
Saif Esmail 80 on at

Like (0)

Report

Thanks Aftab for the quick response. I could guess there is no other work around, the process in my company is to book the receipts under the partent code then apply it according to the detailed breakup. the problem is that these details are not known at the time the receipt is made hence they won't know what GL to be credited with what amount. moreover, the AR accounts are control accounts hence we removed the option of allowing a manual transaction for them so basically they even won't be able to use them under the distribution.

Thanks

Was this reply helpful? Yes No

Community site session details

what is the affect of applying a receipt of a parent customer against a sales document of a child customer when both the customers are having different Receivables GL codes? does GP pass a journal entry for debiting and crediting the customers (differnet)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

what is the affect of applying a receipt of a parent customer against a sales document of a child customer when both the customers are having different Receivables GL codes? does GP pass a journal entry for debiting and crediting the customers (differnet)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates