POSTING NO. SERIES changes from invoice to ORder

lavanyaballurgi

Hello Experts. One more issue with posting numbers... in a Purchase order as soon as I create a new order the POSTING NO. SERIES picks the PURCHASE INVOICE NO. but after a select a VENDOR CODE in PURCHASE ORDER this POSTING NO. SERIES fields changes to PURCHASE ORDER NO.

is this normal? We have different number series for Order & invoice & its a big mess when someone post purchase invoice in purchase order form with purchase order number series instead of purchase invoice.

amolsalvi

Is there any customization done???

Chinmoy

Check the location card to which the vendor belongs. You will find a Numbering tab, where you have option to define a different set of No. Series for postings. I think this is the no. series which is replacing the "Posting No. Series" when the vendor is selected on the PO.

Chn

lavanyaballurgi

Here is the screenshot & coding

Buy-from Vendor No. - OnValidate()
TESTFIELD(Status,Status::Open);
IF ("Buy-from Vendor No." <> xRec."Buy-from Vendor No.") AND
(xRec."Buy-from Vendor No." <> '')
THEN BEGIN
IF HideValidationDialog THEN
Confirmed := TRUE
ELSE
Confirmed := CONFIRM(Text004,FALSE,FIELDCAPTION("Buy-from Vendor No."));
IF Confirmed THEN BEGIN
PurchLine.SETRANGE("Document Type","Document Type");
PurchLine.SETRANGE("Document No.","No.");
IF "Buy-from Vendor No." = '' THEN BEGIN
IF NOT PurchLine.ISEMPTY THEN
ERROR(
Text005,
FIELDCAPTION("Buy-from Vendor No."));
INIT;
PurchSetup.GET;
"No. Series" := xRec."No. Series";
InitRecord;
IF xRec."Receiving No." <> '' THEN BEGIN
"Receiving No. Series" := xRec."Receiving No. Series";
"Receiving No." := xRec."Receiving No.";
END;
IF xRec."Posting No." <> '' THEN BEGIN
"Posting No. Series" := xRec."Posting No. Series";
"Posting No." := xRec."Posting No.";

Chinmoy

No.. OnValidate is not doing the trick... it is done most probably by the location no. series, because this code you have shown us is reading from the xRec.

Chn

vijay_g

Chinmoy wrote:

No.. OnValidate is not doing the trick... it is done most probably by the location no. series, because this code you have shown us is reading from the xRec.

Chn

Exactly, Customization for posting no. series does not seem as it's handled by base system you need to check from where to system taking posting no.(either from purchase setup or location card).

lavanyaballurgi

well we do not have LOCATION.
and good news is that I found out the culprit code... it was

Buy-from Vendor No. - OnValidate()
.....
"Posting No. Series" := "No. Series";

Thanks to all you guys...

Chinmoy

That sounds gr8! However, this may be a customization, because I could not find any such code in the standard India database.

Chn