web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Post Charge/Stock vari...
Microsoft Dynamics AX (Archived)

Post Charge/Stock variation on purchase receipt

(0) ShareShare
ReportReport
Posted on by C.Nabais 25

Hi,

I want to thank in advance if someone can help on this question.

 

Like in AX previous versions I'm tryind to use the Charge/Stock Variation postings to get a specific postings.

So:

- I setup the "Post to charge account in ledger" in AP Parameters.

- I setup  the accounts for Charge and Stock variation on inveoty posting

 

And I'm getting the postings as expected in all accounts:

pastedimage1477392302625v2.png

The only thing that I don't get, as expected, is the way the Purchase, charge account is posted. Is posted as Credit/Correction.

In previous versions these account was posted as debit.

The questions is: is there any way I can get the postings of the Charge account as a regular debit instead of a Creditng/Correction?

 

Note: I don'thave the options for posting credtis as corrections active.

 

Thansk again.

Best regards

Nabaisc

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Nabaisc,

    Can you provide us some additional information on your setup in your current system and the one that you made previously - supposedly in AX2009?! and the difference to what you expect?

    Many thanks,

    Ludwig

  • C.Nabais Profile Picture
    C.Nabais 25 on at

    Hi Ludwig,

    Thanks for the feedback.

    The setup I have referred before is the one I usually use to use the Charge/Stock variation postings.

    I have already search and don't know if there is any other setup with impact on these postings.

    On Invent Posting I have setup the normal accounts: Product receipt, expenditure accounts, and purchase accruals (the ones relevant for the posting of the item receipt).

    The result is that the system uses the accounts expected but the posting of the Charge account is done as a Credit/Correction instead of a normal debit:

    The system does:

    - Purchase accrual: C 10

    * Purchase charge: C -10

    - Purchase stock variation: C 10

    - Product receipt: D 10

    What I expect was:

    - Purchase accrual: C 10

    * Purchase charge: D 10

    - Purchase stock variation: C 10

    - Product receipt: D 10

    The problem is only how the Purchase charge is posted and I was unable to find anything related with this behavior.

    In Ax2009 I didn't got this problem (I have used this kind of setup it in every project), but I think in Ax 2009 the Charge/Stock variation was posted on the invoice posting and in AX2012 is on the Product receipt.

    If you think there is other setup relevant for this issue let me know and I will provide more details.

    Thanks again

    Nabaisc

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Nabaisc,

    I got the same behavior in my demo machine. Basically there is nothing wrong with the account as the 'corrected credit' is equivalent to a debit transaction. It looks a bit odd but to my knowledge there is nothing that you could do here.

    By the way, for what reason do you need this additional posting?

    Ludwig

  • C.Nabais Profile Picture
    C.Nabais 25 on at

    Thanks.

    Yes, at the end the result is the same, but in a report with accumulated balances this amount is deducted on the credit instead of appear in the debit.

    For some accounts this is to much "odd".

    I wanted to understand if I was missing some parameter that could change this or if is just the normal behavior.

    Concerning the reason: in Portugal we have a set of accounts to register the purchases which balances are used fore some legal reports. Since in Ax we can do the purchase directly to inventory, we find out that using the Charge/Stock variation postings we could get those accounts to be posted without additional work, and that has working fine until now that some people are questioning the negative credit posting.

    Thanks again

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi C.Nabais,

    I see. The 'odd' accounting is something you probably have to address to Microsoft. Yet... can you do me a favor and test whether you get the stock variation and charge posting in your system if you create a PO with a negative quantity, that is if you create a return to the vendor?

    Ludwig

  • C.Nabais Profile Picture
    C.Nabais 25 on at

    Hi Ludwig,

    Good question. I didn't have intention to test it today, but I was finalizing the testing's for another issue I have that includes a purchase credit note, so I just check the posting and I got bad news (for me).

    I don't have the Charge/Stock variations postings on the negative receipt or the credit note.

    I suppose I have to give upon these solution in AX 2012 and find another one!!.

    Thanks again.

    C.Nabais

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Here might be an alternative ;-)

    parallel-accounting-according-to-the-cost-of-sales-and-nature-of-expense-accounting-method-1

    Hope this helps,

    Ludwig

  • C.Nabais Profile Picture
    C.Nabais 25 on at

    Thanks Ludwig,

    I will look at this as soon as possible and let you know if I got the expected result.

    C.Nabais

  • nunomaia Profile Picture
    nunomaia 25 Moderator on at

    if I’m not in mistake that behavior in G/L accounts is a customization that is made to the Portugal, since there isn’t any official localization from Microsoft for Portugal.  

  • C.Nabais Profile Picture
    C.Nabais 25 on at

    Hi Ludwig,

    Following your previous recommendation I was able, finally, to setup and test it.

    For invoices it works fine, however, I still have an issue with credits.

    We need to post the credit in a different account. In previous versions we achieve this by setup the Purchase order, Charge account by Sales tax group (we use a different sales tax group for credits).

    I still work on this but I don't see, so far, how to do it using the charges as you recommend.

    Any toughs will be appreciated.

    Thanks again.

    C.Nabais

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans