Finance | Project Operations, Human Resources, ...

Deferral Schedule reference on Purchase order line

(2) Share

Report

Posted on by imran ul haq

3,992

Hi Friends,

I was exploring the Deferral schedule option under Subscription billing module in system and complete the full cycle, but I was trying to find the Deferral schedule reference on the PO lines, but I couldn't find it. I can see the Purchase order on the deferral schedule but not Deferral schedule reference on Purchase order line, Is it by standard or do I miss sometime, may be some setup is required in procurement and sourcing or in Subscription billing itself.

Thanks in advance

Regards,

Imran Ul Haq

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

CA Neeraj Kumar 1,814 on at

Like (0)

Report

Deferral Schedule reference on Purchase order line

Hi @imran ul haq,

Yes, you need to customize if you want the reference of Subscription billing schedule in PurchLine (Purchase Order Lines) or VendInvoiceTrans table (Posted Purchases Invoice lines).

The reference maintained by Microsoft on the Deferral Schedule page is based on below logic, you can utilize the same..

SubBillDeferralScheduleTable >> AccountingDistribution >> SourceDocumentLine >> VendInvoiceTrans

Relations:

1) SubBillDeferralScheduleTable.SubBillDeferralSourceRecType == 4; SubBillDeferralScheduleTable.SourceRecId == AccountingDistribution.RecId

2) AccountingDistribution.SourceDocumentLine == SourceDocumentLine.RecId

3) VendInvoiceTrans.SourceDocumentLine == SourceDocumentLine.RecId; VendInvoiceTrans.TableId == SourceDocumentLine.SourceRelationType

Then if you want to get Purchline, then utilze field of VendInvoiceTrans.PurchaseLineLineNumber.

If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified

Regards,

Neeraj Kumar

Was this reply helpful? Yes No
CA Aman Agrawal 29 on at

Like (1)

Report

Deferral Schedule reference on Purchase order line

Hi @imran ul haq,

I have also checked and MS has not provided any field in the Purchase order/Vendor invoice to capture the Deferral schedule number, for that you need to customize a field.

Moreover, if the requirement can be handled from Deferral schedule form itself as both purchase order and Invoice number is available there, the customization can be avoided. Try to suggest users/business to use Deferral schedule form and they can access the PO/Vendor invoice from their.

Regards,
Aman

Was this reply helpful? Yes No
imran ul haq 3,992 on at

Like (0)

Report

Deferral Schedule reference on Purchase order line

Thanks Martin, you are right question actually meant for F&O.

Regards,

Imran Ul Haq

Was this reply helpful? Yes No
imran ul haq 3,992 on at

Like (0)

Report

Deferral Schedule reference on Purchase order line

Hi Aman,

Thanks for your response.

On accounting distribution, I saw the deferral option but that is for Review the schedule before posting the Invoice, and I believe after posting the Invoice MS should have given the field for capturing the Deferral schedule number as the reference on the purchase order line, same like how they have given the Purchase order reference on the Deferral schedule.

So, it looks like I need to customize it.

Regards,

Imran Ul Haq

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

Like (0)

Report

Deferral Schedule reference on Purchase order line

@imran ul haq Unfortunately, you asked in the general forum without saying which product D365 you had in mind. I think it's about F&O, therefore I moved the thread to Finance | Project Operations, Human Resources, AX, GP, SL forum. Please let us know if it actually belongs somewhere else.

Was this reply helpful? Yes No
Suggested answer

CA Aman Agrawal 29 on at

Like (1)

Report

Deferral Schedule reference on Purchase order line

Hi @imran ul haq,

This is by design and MS has given the deferral option on Purchase order invoice lines and not on Purchase order lines.

You will be able to see the Deferrals option in Purchase order invoice line (Vendor invoice)>> Distribute amounts.

The below screenshot is for your reference.

Regards,

Aman

1 people found this reply helpful.

Was this reply helpful? Yes No