Hello
I want to add PO number in Item Ledger Entry when we post the PO. In Item ledger entry there is an Order no. field but it is empty in case of sales order and Purchase order.
Any suggestion on how I can bring PO number in Item ledger Entry
Okay...
this is the only way option to bring those details right. but this has this type of issues.
But bringing Purchase number details their won't be any issue like this, right?
apart from this if any other option available pls guide me...
thankyouu soo much for time and consideration.
You didn't do anything wrong, I mentioned above, there is a one-to-many situation, not just multiple invoicing, your second line should come from the cost adjustment.
So I don't recommend directly displaying the Document No. here………
Hi
But here we will get the count, but when go insdie same number is displaying over there.
in your screenshot it is displaying the if there is 2 diff sales inv number exist.
is anything i did wrong
Thankyouu Soo much.
So, we can bring both Purchase and sales Numbers like you explained. is there any other technical difficulties if we face later if bring both in the mentioned way.
is reflect on future entries or it will reflect on all the existing entries also
Really appreciate your kind support and help
Yes, because using Flowfield, only one invoice number can be displayed. According to my practice, click on the number behind to view all invoice numbers.
Thanks
ZHU
Thankyou soo much for your time and response.
just one more query, if there is two invoices count will be shown only like 2, 3 etc .we have to go and check what will be other number. pls correct if i understood is wrong.
if am wrong could pls add some screenshots pls..
i really appreciate your kind support
Emmm, the easiest way is to use Flowfield. In fact, the standard Sales Amount does the same.
For example, for Sales, you can add a Count in addition to the Invoice number. If it is not 1, you can click to confirm whether there are multiple invoices.
tableextension 50112 MyExtension2 extends "Item Ledger Entry" { fields { field(50100; InvoiceNumber; Code[20]) { Caption = 'Sales Invoice Number'; FieldClass = FlowField; CalcFormula = lookup("Value Entry"."Document No." where("Item Ledger Entry No." = field("Entry No."), "Document Type" = const("Sales Invoice"))); } field(50101; InvoiceCount; Integer) { Caption = 'Sales Invoice Count'; FieldClass = FlowField; CalcFormula = count("Value Entry" where("Item Ledger Entry No." = field("Entry No."), "Document Type" = const("Sales Invoice"))); } } } pageextension 50113 MyExtension extends "Item Ledger Entries" { layout { addafter("Item No.") { field(InvoiceNumber; Rec.InvoiceNumber) { ApplicationArea = All; } field(InvoiceCount; Rec.InvoiceCount) { ApplicationArea = All; } } } }
Hope this helps.
Thanks.
ZHU
Okay thanks for Detail Reply Zhu.
is there any other option to achieve those result in item led entry.
right now its very difficult to go inside each time and check the details.
Hi, It is not recommended to do this, because there is a one-to-many situation in the system.
For example,
Post Ship first in the Sales order.
Then use Get Shipment Lines... in the sales invoice to post in two invoices.
In this way, when you click Sales Amount in Item Ledger Entries, you will find that there will be two invoices with different invoice numbers.
Not only in this case, for example, when there is an Item Charge, or when the cost is adjusted, new Value Entries will also be generated, so I personally do not recommend this.
Hope this helps.
Thanks.
ZHU
its superb.
if we want to bring posted sales invoice number also there how it will be. right now for entry type sales, Posted sales shipment number which means delivery note number is coming as EDN. so next to it
how can we bring postesd sales invoice number if entry type is sales then posted sales inv and if entry type is purchase then pur order number
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156