COA - Charts of Accounts - D365 Supply Chain Management

Good morning, how are you doing? Let’s learn together the below Concepts related to D365.

Company (Legal entity) – {Suresh Ojha} - Code- “SURE” like USFM.

Number Sequence

     Charts of accounts

Ledger setup (Account structure, Fiscal calendar, COA etc)

Journal - Daily

Here I can create Workflow and set approvals ID’s or Block some users if needed.

Workflow example 

Posting Profile

Example – Here without inventory we can create PO and post the invoice.

Invoiced the same PO

Product – Product information management (Have covered Product master in further slides)

Item – released product

P2P (Procure to Pay) – Created PO, registered and & posted invoices to receive to goods in inventory-

Inventory item model group - Setup.

Pending vendor Invoice

 

P2P - PO invoiced  -Example

Order to Cash - Customer

 

SO invoiced – Order to Cash

Free text invoice (without receiving inventory if want to raise a SO to customer)

Product Master- Product Variant

(S M L XL colour etc), Product attributes, (Milk and medicine- adding field like Expiry date, Hazardous, warranty – this is for reporting purpose and its industry specific), Product categories and Hierarchy (like – Parent, child, grandchild etc.)

Serial number control- Example

Product Variant

 SO invoiced for product variant Item.

Product Attributes - reporting purpose like Milk and Medicine 

P

Transaction on inventory

Charges (Freight) Concept in D365 This includes Freight on line item as well.

Splitting freight charges on 2 items

(See below)For 3^rd PARTY – Just Create a G\L add that to Charge code

3^rd Party charges.

Purchase order return (RMA) - Here we will get Pick option not registration Purchase return on SAME PO with (-) Sign

Purchase return on PO- Partial quantity.

Sales return Order: (Disposition code is important, if Scrap –setup a quarantine warehouse)

Question: Do we get inventory back on all scenario and how we can see the amount has been credited to customer ?

Register back on inventory through disposition code

Delivered to customer or taken further action on Sales return

Posted Sales return order – How can I see inventory movement and Scrap has moved to quarantine warehouse?

Trade agreement: Journal setup, activation and Purpose

1 Scenario - This is just to set a predefine price for vendor and customer related to 1 particular item.

Note – on PO or SO item will take value from Purchase agreement or Sales agreement if not then 3^RD priority is from Trade agreement   

 

Journal Posted

Trade agreement price ($70 and $90) for 1 item with 2 different warehouses.

Cash & Bank management

                                            Created a Bank as SBI

Posted journals on SBI- bank account just to see the transaction 

Setup for check layout

Checks layout Example

Vendor Payment through Checks

Example - #2358

Fixed assets

After all required setups I have acquired “Building

Deprecation posted on building as well

 Building Valuation

Consignment warehouse process

Here Supplier will have  access to company warehouse location to store the inventory and she/he will not charge that until company sell this to customer. Benefit - Supplier will not  bear inventory holding cost etc.

Item model group for Consignment  should be - Moving average or Standard 

Owner inventory setup required.

Then go to Consignment replenishment orders

Inventory received but it belongs to Owner (Supplier)

Inventory received but it belongs to Owner (Supplier)

Now I have done inventory ownership change.

Inventory Ownership change status

Inventory status moved from Supplier to Owner (Legal entity -’SURE’)

Sales Tax concept

After all setup add Sales tax group on Vendor to Post the invoice Journal.

Warehouse

Shelf, Aisle, Bin Example

Distribution Center and warehouse example

Warehouse Management – Concept

1.   Site : geographical location

2.   Warehouse : physical location consist of Aisle, Shelf, Rack, Bins

•         Quarantine whrs – Basically for scrap and quality purpose

•         Transits whrs – goods moving from one whrs to another whrs (In transit – Just to watch)

•         Transfer order – if you are moving inventory from from one whrs to another whrs

•         Inbound – where you received from vendor.

•         Out bound - where you ship to customer

Location ID –A01SHARC03BI01  =  A01(Aisle)-SHA(Shelf)-RC03(Rack)- BI01(Bin)

Intercompany Concept (USFM – SURE)

3 main task Transaction can be post automatically.

1.           Need to create necessary COA

2.           Setup journals names

3.           Posting relationship (between 2 company)

General Ledge module (COA) Intercompany account

              COA       Intercompany A/c

✓           133306 -             intercompany receivable (USMF- SURE)

✓           321365-              intercompany Payable (USMF- SURE)

Journal Setup

Intercompany Journals & Financial Dimensions

Posting relation intercompany accounting (USFM – SURE)

Solicitation Type – Procurement and sourcing – Paraments 

Procurement and sourcing PO automatically created from RFQ

SURESH – read how to add questionnaire in RFQ

Purchase Requisition please add your product on Product categories on Procurement and sourcing

Grant permission so that you can select item from you legal entity

PO cratered through Purchase agreement

Sales Quotation

this is Similar to RFQ where I am going to quote a price for vendor and once the bid is confirmed – SO will be created thru that Sales quotation

Demand forecasting

Demand forecasting, Master planning, workflow, vendor collaboration, Landed cost, Production module

 

Demand forecasting

Manual forecast entry- we can Pull into excel and change the forecast

Ready for analysis