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 NAV (Archived) / Charge Item Assignment...
Microsoft Dynamics NAV (Archived)
Answered

Charge Item Assignment Issue

(0) ShareShare
ReportReport
Posted on by Tharanga Chandrasekara 23,118

Hello Everyone,

Need a little bit of help in Charge Item Assignment. Scenario goes as follows,

At the time of GRN my client does not enter the item cost and they only enter the cost at the time of invoicing. However when they try to assign Item Charges using amount based method value goes as 0 and if they use the equal amount option then NAV divide it equally and assign the values to GRN lines. (They create a separate purchase invoice and add a charge item and then assign the cost)

In the Purch. Rcpt. Line  "Item Charge Base Amount" goes as 0 and it causes the issue of dividing the "Charge Amount" based on the cost.

What is the solution to overcome this issue. They are not in a position to enter the cost at the time of GRN.

EDIT : GRN (Goods Received Notes) means Receive Items in the Purchase Order. 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    Hi Tharanga,

    no idea what GRN is... I assume it's something in the order process.

    When you take the tour of where the base amount for the distribution comes from, you can see that it's the field "Item Charge Base Amount" in the purchase receipt lines (or in all the other possible shipment and receipt lines). You can see this in CU5805, function SuggestAssgnt2(). Now is the question where this field is filled in. PRISM says it's in CU90, on the insertion of the purchase receipt line. The amount itself is the part of the purchase line amount proportional to the quantity you're receiving. If this is zero at receipt time, then you have no item charge base amount for the distribution of charges later on.

    A possible solution would be to extend the generation of CostBaseAmount in CU90:

    ...
  IF PurchLine.FINDSET THEN
    REPEAT
      IF PurchLine.Type = PurchLine.Type::Item THEN
        DummyTrackingSpecification.CheckItemTrackingQuantity(
          DATABASE::"Purchase Line",PurchLine."Document Type",PurchLine."Document No.",PurchLine."Line No.",
          PurchLine."Qty. to Receive (Base)",PurchLine."Qty. to Invoice (Base)",Receive,Invoice);
      IF PurchLine."Job No." <> '' THEN
        PurchLine.TESTFIELD("Job Task No.");
      ItemJnlRollRndg := FALSE;
      LineCount := LineCount + 1;
      IF GUIALLOWED THEN
        Window.UPDATE(2,LineCount);
      IF PurchLine.Type = PurchLine.Type::"Charge (Item)" THEN BEGIN
        PurchLine.TESTFIELD(Amount);
        PurchLine.TESTFIELD("Job No.",'');
      END;

      IF PurchLine.Type = PurchLine.Type::Item THEN
            //OS001s os.jgl
        if PurchLine."Line Amount" <> 0 then
          CostBaseAmount := PurchLine."Line Amount"
        else
          CostBaseAmount := PurchLine."Unit Cost (LCY)" * PurchLine.Quantity;
        //OS001e os.jgl
      UpdateQtyPerUnitOfMeasure(PurchLine);
      IF PurchLine.Type = PurchLine.Type::"Fixed Asset" THEN BEGIN
        PurchLine.TESTFIELD("Job No.",'');
        PurchLine.TESTFIELD("Depreciation Book Code");
        PurchLine.TESTFIELD("FA Posting Type");
        FA.GET(PurchLine."No.");
        DeprBook.GET(PurchLine."Depreciation Book Code");
        FA.TESTFIELD("Budgeted Asset",FALSE);
        IF PurchLine."Budgeted FA No." <> '' THEN BEGIN
          FA.GET(PurchLine."Budgeted FA No.");
          FA.TESTFIELD("Budgeted Asset",TRUE);
        END;
        IF PurchLine."FA Posting Type" = PurchLine."FA Posting Type"::Maintenance THEN BEGIN
...

    When there is no amount, then the unit cost amount (LCY) will be used. This would have to be done for every case where this can happen (CU80, 90, 598x).

    with best regards

    Jens

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    Thank you for the reply.

    Modification you mentioned is already in place and even the modification can't handle when they receive a new item. Because "Unit Cost (LCY)" is 0 at the initial purchase.

  • Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    Hi Tharanga,

    that's unfortunate. They don't have a list price for items?

    with best regards

    Jens

  • Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    They get the vendor invoice after few days time.

  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    You could enter a guesstimated price in the field "last direct cost" in the newly created item. This would be fetched if the direct cost of the item is 0. I assume you're talking about a wide variety of items and prices, so this guesstimate would be better than quantity for the distribution of the cost.

    For direct cost, however, you can change the direct cost amount of the invoice lines directly (after pulling the purchase receipts). They do this, do they?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    A couple of suggestions.  The allocation by amount is a simple way to create a % allocation rather than equally to each line.  You could also develop allocation options for weight or quantity as the divisor and default the cursor to quantity of each receiving document line, for example.  While this would give you a different allocation than using amount, it would still be an equitable method to allocate freight cost by unit.  

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 NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans