Open Forum

Expand all | Collapse all

Wrong Signs on Purchase Invoice/Credit Memo using Item Charge items assign to Sales Shipment

  • 1.  Wrong Signs on Purchase Invoice/Credit Memo using Item Charge items assign to Sales Shipment

    GOLD CONTRIBUTOR
    Posted Sep 13, 2019 04:28 PM

    We are on Version US Dynamics NAV 8.0.37874.0. (RTM), which means there might be a fix for it on our version.

     As you can see in this screenshot, the inventory was shipped.  Then a purchase invoice for a item charge in the amount of $25.  It went under the column of "Cost Amount (Non-Invbtl.)".  Then I did a credit memo, but it posted it with the same sign.  I believe they should be different signs.  Do you know if this has been fixed or any ideas on how to get around this?

     This is using the Demo Database that comes on the disc.

    Showing Cost Amount being the same sign on both Purchase Invoice and Purchase Credit Memo


    ------------------------------
    Jonathan Delfraisse
    Computer Specialist
    MANCON
    Virginia Beach VA
    NAV 2015
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Wrong Signs on Purchase Invoice/Credit Memo using Item Charge items assign to Sales Shipment

    SILVER CONTRIBUTOR
    Posted Sep 16, 2019 12:25 PM
    Hi Jonathan,

    This may be a dumb question but when you entered the credit, di you use a negative sign ("-")?  Credits should be entered without a negative sign as the system already knows you are using a Credit Memo.

    ------------------------------
    Jenifer Elliott
    Senior Application Consultant
    Technology Management Concepts
    807 Parkview Drive North, Suite 150
    El Segundo, CA 90245
    Phone: 831.277.3280
    Email: jelliott@tmc-la.com
    Website: www.abouttmc.com







    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Wrong Signs on Purchase Invoice/Credit Memo using Item Charge items assign to Sales Shipment

    GOLD CONTRIBUTOR
    Posted Sep 16, 2019 03:13 PM
    I did double check just in case, yeah, the quantity is a positive number (1).  In the Cronus database, the G/L entries look okay. After some code searching, I did find that it uses the "ItemJnlLine.Amount" directly.  It only checks to see if the Entry Type is "Purchase" from the Item Journal Line.  I checked the latest version of Nav.  It is the same code.  The fix might be to look at the Document Type of "credit memo" and multiply by -1, but I can't test it due to my license.

    ------------------------------
    Jonathan Delfraisse
    Computer Specialist
    MANCON
    Virginia Beach VA
    NAV 2015
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Wrong Signs on Purchase Invoice/Credit Memo using Item Charge items assign to Sales Shipment

    SILVER CONTRIBUTOR
    Posted Sep 16, 2019 03:18 PM
    The Qty and the Unit Price both have to be positive numbers.

    ------------------------------
    Jenifer Elliott
    Senior Application Consultant
    Technology Management Concepts
    807 Parkview Drive North, Suite 150
    El Segundo, CA 90245
    Phone: 831.277.3280
    Email: jelliott@tmc-la.com
    Website: www.abouttmc.com







    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Wrong Signs on Purchase Invoice/Credit Memo using Item Charge items assign to Sales Shipment

    GOLD CONTRIBUTOR
    Posted Sep 17, 2019 09:47 AM
    Confirmed.  Both quantity and direct unit cost are positive numbers.
    Posted Purchase Credit Memo


    ------------------------------
    Jonathan Delfraisse
    Computer Specialist
    MANCON
    Virginia Beach VA
    NAV 2015
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Wrong Signs on Purchase Invoice/Credit Memo using Item Charge items assign to Sales Shipment

    GOLD CONTRIBUTOR
    Posted Sep 17, 2019 10:52 AM
    So I did a test post in version Dynamics NAV 13 (Dynamics 365 Business Central) - 13.0.24623.0.
    Looks like they fixed it some time between my version and this version.  Now just to find where the fix is in the code and apply to my version.

    ------------------------------
    Jonathan Delfraisse
    Computer Specialist
    MANCON
    Virginia Beach VA
    NAV 2015
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: Wrong Signs on Purchase Invoice/Credit Memo using Item Charge items assign to Sales Shipment

    SILVER CONTRIBUTOR
    Posted Sep 17, 2019 10:58 AM
    The easiest way to do that would be to look for Cumulative Updates for your version.  It will be listed as something MS has fixed.

    ------------------------------
    Jenifer Elliott
    Senior Application Consultant
    Technology Management Concepts
    807 Parkview Drive North, Suite 150
    El Segundo, CA 90245
    Phone: 831.277.3280
    Email: jelliott@tmc-la.com
    Website: www.abouttmc.com







    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role