Hello,
I am new to NAV, any help will be appreciated.
I have created the new field in the Punching master table as"shipped"(boolean).
My problem is -
when i ship the quantity from the sales order form then the shipped field for the particular serial number in the punching card master should be checked as true.
Regards,
Aditi
*This post is locked for comments
How it got resolved?
Pl. mark the relevant answer verified, if it helped you.
Thank you for your advice :)
I resolved the issue.
As I can see, your code seems correct and you should be able to update the boolean field properly, provided you have the data available in the respected table.
Debug the code and try to find out the reason.
Ideally, you should not write such Repeat Until loop in Posting the Sales Order. This should affect the performance very badly.
Check the possibilities of inserting the same code in CU 22 as mentioned above.
Meanwhile, have you debug your above code and checked, if you are finding the reservation entries and related punching master record for required updation?
Also,
Hello,
Thanks for the reply.
I have written the code in the CU-80- sales post.
when i click on post and choose ship then after shipping the Boolean value should be updated in the punching master as true.
following is the code i have written :
//START-032
lrecReservationEntry.RESET;
lrecReservationEntry.SETRANGE("Item No.",SalesLine."No.");
lrecReservationEntry.SETRANGE("Source ID",SalesLine."Document No.");
lrecReservationEntry.SETRANGE("Source Ref. No.",SalesLine."Line No.");
lrecReservationEntry.SETRANGE("Source Type",DATABASE::"Sales Line");
lrecReservationEntry.SETRANGE("Source Subtype",1);
IF lrecReservationEntry.FINDSET THEN BEGIN
REPEAT
lrecPunchingMaster.RESET;
lrecPunchingMaster.SETFILTER("Item No.",lrecReservationEntry."Item No.");
lrecPunchingMaster.SETFILTER("W.O.No.",lrecReservationEntry."Source ID");
lrecPunchingMaster.SETRANGE("W.O.Line. No.",lrecReservationEntry."Source Ref. No.");
lrecPunchingMaster.SETFILTER("Valve Serial No.",lrecReservationEntry."Serial No.");
IF lrecPunchingMaster.FINDFIRST THEN
BEGIN
lrecPunchingMaster.Shipped:=TRUE;
lrecPunchingMaster.MODIFY;
END;
UNTIL lrecReservationEntry.NEXT=0;
END;
//STOP-032
with this code i am unable to update the Boolean value.
Punching Master table seems customized table.
You really need to go through the code and relatively update the field while posting the sales shipment.
In case, if you have unique Serial No. record in Punching Master, you can write the code in CU 22 - InsertItemLedgerEntry Function to update the boolean at Punching Master table.
Hope this helps.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
