Sales Invoice Posting Restriction for Transit Days

Stivan_dsouza21Stivan_dsouza21 Member Posts: 218
1.We want a field in Customer Master named “Transit Days" for that datatype will be Text or Code.
2.We want that any Sales Order can be posted for a customer on a posting date ofsales header equal to greater than Items India Release date(Datatype is DATE) – Customer’s Transit days(Datatype may be Text or Code). So if a bill has multiple items then the latest India release date of all the Items in the Sales lines should be considered for posting the Invoice.
Thanks & Regards,
Stivan D'souza

Comments

  • mohana_cse06mohana_cse06 Member Posts: 5,504
    1.We want a field in Customer Master named “Transit Days" for that datatype will be Text or Code.
    2.We want that any Sales Order can be posted for a customer on a posting date ofsales header equal to greater than Items India Release date(Datatype is DATE) – Customer’s Transit days(Datatype may be Text or Code). So if a bill has multiple items then the latest India release date of all the Items in the Sales lines should be considered for posting the Invoice.

    what did you try as of now?
    You should tell us what you have tried also rather than what you want.
  • Stivan_dsouza21Stivan_dsouza21 Member Posts: 218
    1) Still now i have worked on how to find the biggest India Release Date: The Code is as follows
    Date := WORKDATE;
    SalesLine.RESET;
    SalesLine.SETRANGE("Document No.","No.");
    SalesLine.SETRANGE(SalesLine.Type,SalesLine.Type::Item);
    IF SalesLine.FINDSET THEN
    IF Date < SalesLine."India Release Date" THEN BEGIN
    REPEAT
    Date := SalesLine."India Release Date";
    UNTIL SalesLine.NEXT=0;
    END;
    2) Now i want to check the customer on a posting date ofsales header equal to greater than Items India Release date(Datatype is DATE) – Customer’s Transit days(Datatype may be Text or Code).
    Thanks & Regards,
    Stivan D'souza
Sign In or Register to comment.