Customers All types of Transactions SQL Table/view

(0) Share

Report

Posted on by sandipdjadhav

18,297

Do anyone help me to create views in sql to show Customer All types transactions that include from Sales Orders, Sales Invoice, RM Invoices, Return, Credit Memo, Debit Memo etc?

Your earliest reply is highly appreciable.

Thanks

Sandip

*This post is locked for comments

All responses (3)

Answers (0)

sandipdjadhav 18,297 on at

Like (0)

Report

RE: Customers All types of Transactions SQL Table/view

Moh'd,

I will be waiting for your script.

Appreciate for your response.

Thanks

Sandip
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Customers All types of Transactions SQL Table/view

Hey Sandip,

I already have a cumulative script for all sales transactions including SOP and RM, you may drop me a mail and I shall get back to you with the full script
Suggested answer

Victoria Yudin 22,768 on at

Like (0)

Report

RE: Customers All types of Transactions SQL Table/view

Hi Sandip,

Would something like this help?

victoriayudin.com/.../sql-view-with-all-posted-receivables-transactions

It does not have sales orders or unposted invoices, for that you might want to include some data from this:

victoriayudin.com/.../sql-view-with-all-sop-line-items or some variation of that.