Create PO invoice without posting it using PurchFormLetter framework

(1) Share

Report

Posted on by Community Member

Hi good folks,

I'd like to create a supplier pending invoice using the PurchFormLetter module without attempting to post it.

it seems that PurchFormLetter.StartOperation() && purchFormLEtter.update() will attempt to post the pending invoice after creating it.

I have thought about adding a parameter to the data contract and checking against that in the posting process but i am wondering if there is an existing parameter that will do that !

code looks like:

Purchformletter = purchformletter::construct(DocumentStatus::Invoice);
    
purchformletter.parmParmTableNum("InvoiceId");
Purchformletter.purchTable(purchtable); 

purchParmUpdate = purchformletter.purchParmUpdate();
purchParmUpdate.SumNum = "IGU + 20147856434-11";
    
purchformletter.initParameters(purchParmUpdate,
                        Printout::Current);  // Printout
purchformletter.chooseLines(true);
    
Purchformletter.selectFromJournal(selectedList.pack());

purchformletter.sumBy(AccountOrder::None);
purchformletter.reArrangeNow(true);
purchformletter.reArrange();
purchformletter.specQty(purchupdate::PackingSlip);

purchformletter.startOperation();

thanks for your help.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (0)

Report
Hi Zain,

You don't need to call neither startOperation nor update. chooseLines will create VendInvoiceInfoTable and VendInvoiceInfoLine for you and all you need is to make it pending.

purchParmUpdate purchParmUpdate; PurchTable purchtable = purchtable::find('POxxxxx'); PurchFormLetter purchFormLetter = PurchFormLetter::construct(DocumentStatus::Invoice); purchformletter.parmParmTableNum("xxxxx"); purchformletter.purchTable(purchtable); purchformletter.specQty(purchupdate::All); purchParmUpdate = purchformletter.purchParmUpdate(); purchParmUpdate.SumNum = "xxxxx"; purchformletter.initParameters(purchParmUpdate, Printout::Current); // Printout purchformletter.chooseLines(true); VendInvoiceInfoTable::moveFromActiveToSaved(VendInvoiceInfoTable::findRecId(purchformletter.parmLastParmTableRecId()));

Was this reply helpful? Yes No
Martin Dráb 237,805 Most Valuable Professional on at

Like (1)

Report

Wouldn't a proforma invoice do the job? (Maybe not, I'm not sure what exactly it saves.)

Note that if you want to know what the framework does (such as which parameters it considers), you can look into its code.

(I see I was too late and Ievgen has probably a better answer, but I'll keep it here for completeness.)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ievgen,

absolutely brilliant thank you!

I am creating the invoice using a product receipt supplied in the packed list. so moving the order of lines a bit i get exactly what i need "a pending PO supplier invoice from a product receipt" w/o form prompting or posting attempts.

Final result for those interested:

Purchformletter = purchformletter::construct(DocumentStatus::Invoice);

purchformletter.parmParmTableNum("InvoiceNumber");

Purchformletter.purchTable(purchtable);

purchParmUpdate = purchformletter.purchParmUpdate();

purchParmUpdate.SumNum = "InvoiceNumber";

purchformletter.initParameters(purchParmUpdate, Printout::Current); // Printout

purchformletter.sumBy(AccountOrder::None);

purchformletter.reArrangeNow(true);

purchformletter.reArrange();

purchformletter.specQty(purchupdate::ALL);

purchformletter.chooseLines(true);

Purchformletter.selectFromJournal(selectedList.pack()); //where product receipt is supplied

VendInvoiceInfoTable::moveFromActiveToSaved(VendInvoiceInfoTable::findRecId(purchformletter.parmLastParmTableRecId()));

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your input Martin, I tried the proforma option and it attempted to post it as well. but I need a normal invoice for my solution. thanks for your response, always appreciated.

Was this reply helpful? Yes No
Martin Dráb 237,805 Most Valuable Professional on at

Like (0)

Report

Proforna invoices are not really posted, that's the whole point. Don't get confused by the fact that they need to do the same calculations and temporarily fill in the same tables to be able to print the invoice report.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ievgen,

Thanks for your code, I have a similar requirement to use the purchFormLetter framework to only pull lines from a PO into an already existing Pending vendor invoice header record. I don't want to create a new invoice record. How do I achieve this?

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

Thank you for the post kind sir. This has proved helpful to me.

Was this reply helpful? Yes No
venkatpasumarthi 125 on at

Like (0)

Report

Hi Krishna,

did you achieve this? I am having the same requirement. if yes, I would appreciate if you share your code.

Was this reply helpful? Yes No