Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Lisa Ng]

Hi All, 
After I created a charge code (screenshot 1), I went into PO line and added a charge (screenshot 2 & 3).  Then I clicked on Allocate charges, it gives me this error:
“The charge FREIGHT cannot be allocated because no lines match your selection criteria“. What does this mean?  Do I need to add a line to this PO?  Please suggest. Thanks so much!

——————————
Lisa Ng
Business Analyst
HOUSTON TX
——————————

[Jamie Loeks]

Lisa,

It appears the PO is already fully invoiced thus there are no active lines to burden the charge against.  So if you do need to add this charge you would need to add a new line in order to burden the charge against so it can be invoiced. Since the PO is already invoiced you can’t add the additional charge in a normal means as it’s already financially closed.  Keep in mind the charge could have been added at the invoice stage as well prior to posting. 

Hope this helps

——————————
Jamie Loeks
MCA Connect
Denver CO
——————————
——————————————-

[Lisa Ng]

Hi Ludwig/Jamie,
Thank you for your responses.  If I have additional charges after I invoiced the PO such as delivery and insurance, I would need to add these charged to my cost of goods or cost of inventory.  When I added the charge, I didn’t’ see my cost increase.  The system told me the charge is not posted.  I need to allocate.  Am I doing it wrong or am I missing steps?

Thanks

——————————
Lisa Ng
Business Analyst
NA
HOUSTON TX
——————————
——————————————-

[Grace Gillenwater]

?Lisa,

Since the PO is invoiced, you will not be able to enter any additional charges.  When the additional charges come in at a later time, we enter the charges through an Invoice Journal. Keep in mind, the general ledger account number must be checked to “allow for manual entry.” I am in AX2012 R3, but I assume the same logic is in D365.

Typically our Inventory accounts do not allow for manual entry, so we created some Cost of Goods accounts specific to any additional charges that may be assessed by the vendor – i.e – freight. These COGS accounts are a separate sequence of numbers so we can easily identify additional charges. These COGS accounts all roll up together, so it should be included in your total cost of inventory.

Hope this helps!

——————————
Grace Gillenwater
Accounting Clerk
Landau Uniforms
Olive Branch MS
——————————
——————————————-

[Lisa Ng]

Thank you, Grace, for your response.  You mentioned “Invoice journal”, did you mean AP invoice journal below? At the journal line, do you debit inventory account? (screenshot 2).  If so, how do you reference it to the PO?  Also, do you do 2-ways matching here? Thanks so much!

——————————
Lisa Ng
Business Analyst
NA
HOUSTON TX
——————————
——————————————-

[Grace Gillenwater]

Hi Lisa,

Yes mam, I was referring to an AP Invoice journal.  When you enter to AP voucher line, you would enter the Ledger account number associated with your FREIGHT code. In looking at your screen shot below, you would enter 43007.  You want to make sure Acct # 43007 is for set up to allow for Manual Entry. (box is not checked).  I have attached a screenshot of how our Freight COGS account is set up in AX2012? under the General Ledger and the Charges Code Table under AP.

As for referencing the PO #, you should be able to enter this number in the Description field of the invoice journal. This field is under the GENERAL tab of the Invoice journal – under Account Selection.  I personalized my screen and added this field to the Overview Tab.

You may be able to add a comment to the Invoiced Purchase Order.  I just now was able to add a comment to an Invoiced PO in AX2012, so I would assume you could as well in D365.  The comment was added to the Vendor Reference Field of the PO Header. The comment could be something like: “Freight charged on AP Voucher #xxxxxxx;” or “See AP Invoice the Journal Number xxxx.”

Hope this helps!

??

——————————
Grace Gillenwater
Accounting Clerk
Landau Uniforms
Olive Branch MS
——————————
——————————————-

[Lisa Ng]

Thank you, Grace, for taking the time to write a response.  I’ll test it.  Thanks

——————————
Lisa Ng
Business Analyst
NA
HOUSTON TX
——————————
——————————————-

[Nirav Modi]

?Good Day Lisa,

Charges Adjustment will help you after Invoice, Please Explore this Functionality.

Invoice Journal –> Charges –> Adjustment.

——————————
Nirav Modi
Project Manager – Ax
Indusa
http://www.indusa.com
00919426381531
——————————
——————————————-

[Lisa Ng]

Hi Nirav,
Now I add a charge to the PO at the PO invoice. 
1. Is there a button to post? 
2. How do I run a report to see the cost roll up for this particular PO? 
Thank so much!

——————————
Lisa Ng
Business Analyst
NA
HOUSTON TX
——————————
——————————————-

[Ludwig Reinhard]

Hi Lisa,
If you already added your charges to your PO lines, why do you still want to allocate something?
The charge allocation feature does nothing else then distributing charges specified at the header level.
Would be great if you could clarify of what you try to achieve exactly.
Many thanks and best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor EMEA
Goettingen
——————————
——————————————-