Blog

Relation between VendPackingSlipTrans and VendInoiceTRans D365 Finance and Operation

May 27, 2024 by alirazazaidi

One of my young colleuge needs a query so he can get packingslip line agains vend inoice trans. He was developing some report for procurement and sourcing.

I found my documentation about something similar almost 9 years ago.

Relation between VendPackingSlipTrans and VendInoiceTRans Dynamics Ax 2012

But a lot of things change from Ax 2012 to d365 Finance and operations.

Now if you required something similar following query will work.

VendInvoicePackingSlipQuantityMatch vendInvoicePackingSlipQuantityMatch;
VendPackingSlipTrans vendPackingSlipTrans;

        select firstonly vendPackingSlipTrans
            exists join vendInvoicePackingSlipQuantityMatch
                where vendInvoicePackingSlipQuantityMatch.InvoiceSourceDocumentLIne == VendPackingSlipTrans.SourceDocumentLine &&
                      vendPackingSlipTrans.SourceDocumentLine == vendInvoicePackingSlipQuantityMatch.PackingSlipSourceDocumentLine;

Custom Cell format – Excel for Consultant

April 10, 2024 by alirazazaidi

I was doing some data cleansing and data entry I was facing problem

for number in such a way 4 digits: 0001, 0002, … , 1000 etc.

Now I do not want to type “0001” in excel, instead I wanted to type 1 and I want excel to convert that to 0001 for me. So I started looking for a custom cell format and dug a little deeper to understand those. I thought it would be nice to share them to you all.

First take a look at how the cell formatting dialog box – number tab looks like:

I found two things for

Special: Used for phone number, zipcode, social security number formats depending on the locale you select. For eg. for US they would be phone number [xxx-xxx-xxxx], ssn [xxx-xx-xxxx], zipcode[xxxxx, xxxxx-xxxx].

Custom: Used for creating your own cell formatting structure.

Ok, without further confusion, this is probably how you can use the custom cell formatting feature in Microsoft excel.