Monday, 22 June 2015

Inventory Serial Controls In Inventory Organization Parameter

Assuming SN100 as Serial Number and two Items in each org A & B Serial Control is Illustrated below.

The Precedence or hierarchy of Option is 

1.within Inventory Items (Allow Unique Serial Number For Each Item)
2.Within Organization (Allow Unique Serial Number for Each Item and Organization)
3.Across Organization (Allow Unique Serial Number regardless Item/Organization)









Org1

Org2

Org3
Remarks









A
B
A
B
A
B

Across Organization







SN100
Y
N
N
N
N
N
SN100 Can be Used Only Once regardless of Item/Org Combination
Within Organization







SN100
Y
N
N
Y/N
N
Y/N
SN100 Can be Used for Item B in any one of Other Two Orgs
Within Inventory Items







SN100
Y
Y/N
N
Y/N
N
Y/N
SN100 Can be Used for Item B But In only one Org

Sunday, 21 June 2015

Oracle Purchasing - P2P Accounting Entries

 A Simple Flow P2P Accounting Entry is Shown Below.



Sl No
Stage
Debit A/c
Credit A/C




1
At PO Generation
Nil
Nil




2
At Receiving



Receiving Inventory A/c
100


Inv AP Accrual A/C

100




3
At Inspection
Nil
Nil




4
During Delivery to Stores



Material A/c
100


Receiving Inventory A/c

100




5
At Invoice Generation



Inv AP Accrual A/C
100


Liability A/c

100




6
During Payment



Liability A/c
100


Bank A/c

100