Specification of the various GL-entries for arapXML
c. Use
case: Submit GL transactions
The entries to ARAP represents a
purchase of goods or services like this:
| Ledger |
TransactionSet |
| CustomerCo |
|
|
|
transactionId: #5
transactionDate:2001/07/21
transactionDoc: #454
originalTransactionId: #4567
periode: july 2001
is posted: false
groupId: #999 |
|
transaction
Id |
entryId |
entry
Date |
entry
Doc |
entry
Journal
Type |
Account |
Dr/Cr |
Amount |
Party |
partys
Doc |
partys
User |
Product
Or
Service |
Quantity |
product
Measure |
settlement
method |
terms |
tax
type |
| #5 |
#1 |
2001/07/21 |
#454 |
R |
Purchases |
D |
1000 |
Seller
Company |
#25367 |
web
Store1 |
Widgets |
5 |
litre |
|
|
#235 |
| #5 |
#2 |
2001/07/21 |
#454 |
C |
AP |
C |
1100 |
Seller
Company |
#25367 |
web
Store1 |
|
|
|
30days |
#44 |
|
| #5 |
#3 |
2001/07/21 |
#454 |
B |
tax
Payable |
D |
100 |
tax
Agenscy3 |
#25367 |
|
|
|
|
|
|
#235 |
| #5 |
#4 |
2001/07/21 |
#454 |
B |
inventory |
D |
500 |
|
#25367 |
|
Widgets |
5 |
litre |
|
|
|
| #5 |
#4 |
2001/07/21 |
#454 |
B |
inventory |
D |
500 |
|
#25367 |
|
product 1 |
50 |
pieces |
|
|
|
| #5 |
#5 |
2001/07/21 |
#454 |
R |
change in
inventory |
C |
1000 |
|
#25367 |
|
|
|
|
|
|
|
|
|
|
|
The entries to the BSP's ARAP represents a sale of goods or
services like this:
| Ledger |
TransactionSet |
| CustomerCo |
|
|
|
transactionId: #66
transactionDate:2001/07/21
transactionDoc: #789
originalTransactionId: #4567
periode: july 2001
is posted: false
groupId: #999 |
|
transaction
Id |
entryId |
entry
Date |
entry
Doc |
entry
Journal
Type |
Account |
Dr/Cr |
Amount |
Party |
partys
Doc |
partys
User |
Product
Or
Service |
Quantity |
product
Measure |
settlement
method |
terms |
tax
type |
| #66 |
#11 |
2001/07/21 |
#25367 |
R |
Sales |
C |
1000 |
buyer
Company |
|
owner |
Widgets |
5 |
litre |
|
|
#235 |
| #66 |
#12 |
2001/07/21 |
#25367 |
S |
AR |
D |
1100 |
buyer
Company |
|
owner |
|
|
|
30days |
#44 |
|
| #66 |
#13 |
2001/07/21 |
#25367 |
B |
tax
Payable |
C |
100 |
tax
Agenscy3 |
|
|
|
|
|
|
|
#235 |
| #66 |
#14 |
2001/07/21 |
#25367 |
B |
inventory |
C |
400 |
|
|
|
product 1 |
50 |
pieces |
|
|
|
| #66 |
#15 |
2001/07/21 |
#25367 |
B |
inventory |
C |
435 |
|
|
|
Widgets |
5 |
litre |
|
|
|
| #66 |
#16 |
2001/07/21 |
#25367 |
R |
change in
inventory
(COGS) |
D |
835 |
|
|
|
|
|
|
|
|
|
|
|
|
|
d. Use
case: Receive and accept goods and service when delivery is according to
acknowledgement
The new entries to ARAP.
| Ledger |
TransactionSet |
| CustomerCo |
|
|
|
transactionId: #5
transactionDate:2001/07/21
transactionDoc: #454
originalTransactionId: #4567
periode: july 2001
is posted: true
groupId: #999 |
|
transaction
Id |
entryId |
entry
Date |
entry
Doc |
entry
Journal
Type |
Account |
Dr/Cr |
Amount |
Party |
partys
Doc |
partys
User |
Product
Or
Service |
Quantity |
product
Measure |
settlement
method |
terms |
tax
type |
| #5 |
#1 |
2001/07/21 |
#454 |
R |
purchases |
D |
1000 |
Seller
Company |
#25367 |
web
Store1 |
Widgets |
5 |
litre |
|
|
#235 |
| #5 |
#2 |
2001/07/21 |
#454 |
C |
AP |
C |
1100 |
Seller
Company |
#25367 |
web
Store1 |
|
|
|
30days |
#44 |
|
| #5 |
#3 |
2001/07/21 |
#454 |
B |
tax
Payable |
D |
100 |
tax
Agenscy3 |
#25367 |
|
|
|
|
|
|
#235 |
| #5 |
#4 |
2001/07/25 |
#520 |
B |
inventory |
D |
500 |
|
#685 |
|
Widgets |
5 |
litre |
|
|
|
| #5 |
#5 |
2001/07/25 |
#520 |
B |
inventory |
D |
500 |
|
#685 |
|
product 1 |
50 |
pieces |
|
|
|
| #5 |
#6 |
2001/07/25 |
#520 |
R |
change in
inventory |
C |
1000 |
|
#685 |
|
|
|
|
|
|
|
|
|
|
The new entries to the BSP's
ARAP.
| Ledger |
TransactionSet |
| CustomerCo |
|
|
|
transactionId: #66
transactionDate:2001/07/21
transactionDoc: #789
originalTransactionId: #4567
periode: july 2001
is posted: true
groupId: #999 |
|
transaction
Id |
entryId |
entry
Date |
entry
Doc |
entry
Journal
Type |
Account |
Dr/Cr |
Amount |
Party |
partys
Doc |
partys
User |
Product
Or
Service |
Quantity |
product
Measure |
settlement
method |
terms |
tax
type |
| #66 |
#11 |
2001/07/21 |
#25367 |
R |
Sale |
C |
1000 |
buyer
Company |
#PO33 |
owner |
Widgets |
5 |
litre |
|
|
#235 |
| #66 |
#12 |
2001/07/21 |
#25367 |
S |
AR |
D |
1100 |
buyer
Company |
#PO33 |
owner |
|
|
|
30days |
#44 |
|
| #66 |
#13 |
2001/07/21 |
#25367 |
B |
tax
Payable |
C |
100 |
tax
Agenscy3 |
#PO33 |
|
|
|
|
|
|
#235 |
| #66 |
#14 |
2001/07/25 |
#685 |
B |
inventory |
C |
400 |
|
#PO33 |
|
product 1 |
50 |
pieces |
|
|
|
| #66 |
#15 |
2001/07/25 |
#685 |
B |
inventory |
C |
435 |
|
#PO33 |
|
Widgets |
5 |
litre |
|
|
|
| #66 |
#16 |
2001/07/25 |
#685 |
R |
change in
inventory
(COGS) |
|
|
|
|
e. Use
case: Receive and accept goods and service when delivery is NOT according to
acknowledgement
The new entries to
ARAP: The
original transaction.
| Ledger |
TransactionSet |
| CustomerCo |
|
|
|
transactionId: #5
transactionDate:2001/07/21
transactionDoc: #454
originalTransactionId: #4567
periode: july 2001
is posted: true
groupId: #999 |
|
transaction
Id |
entryId |
entry
Date |
entry
Doc |
entry
Journal
Type |
Account |
Dr/Cr |
Amount |
Party |
partys
Doc |
partys
User |
Product
Or
Service |
Quantity |
product
Measure |
settlement
method |
terms |
tax
type |
| #5 |
#1 |
2001/07/21 |
#454 |
R |
purchases |
D |
1000 |
Seller
Company |
#25367 |
web
Store1 |
Widgets |
5 |
litre |
|
|
#235 |
| #5 |
#2 |
2001/07/21 |
#454 |
C |
AP |
C |
1100 |
Seller
Company |
#25367 |
web
Store1 |
|
|
|
30days |
#44 |
|
| #5 |
#3 |
2001/07/21 |
#454 |
B |
tax
Payable |
D |
100 |
tax
Agenscy3 |
#25367 |
|
|
|
|
|
|
#235 |
| #5 |
#4 |
2001/07/25 |
#520 |
B |
inventory |
D |
400 |
|
#685 |
|
Widgets |
5 |
litre |
|
|
|
| #5 |
#5 |
2001/07/25 |
#520 |
B |
inventory |
D |
500 |
|
#685 |
|
product 1 |
50 |
pieces |
|
|
|
| #5 |
#6 |
2001/07/25 |
#520 |
R |
change in
inventory |
C |
900 |
|
#685 |
|
|
|
|
|
|
|
|
|
|
|
ARAP transactions due to the
creditmemo.
| Ledger |
TransactionSet |
| CustomerCo |
|
|
|
transactionId: #8
transactionDate:2001/07/29
transactionDoc: #530
originalTransactionId: #5020
periode: july 2001
is posted: true
groupId: #999 |
|
transaction
Id |
entryId |
entry
Date |
entry
Doc |
entry
Journal
Type |
Account |
Dr/Cr |
Amount |
Party |
partys
Doc |
partys
User |
Product
Or
Service |
Quantity |
product
Measure |
settlement
method |
terms |
tax
type |
| #8 |
#12 |
2001/07/29 |
#600 |
R |
purchases |
C |
100 |
Seller
Company |
#699 |
web
Store1 |
|
|
|
|
|
#235 |
| #8 |
#13 |
2001/07/29 |
#600 |
C |
AP |
D |
110 |
Seller
Company |
#699 |
web
Store1 |
|
|
|
30days |
#44 |
|
| #8 |
#14 |
2001/07/29 |
#600 |
B |
tax
Payable |
C |
10 |
tax
Agenscy3 |
#699 |
|
|
|
|
|
|
#235 |
|
|
|
The new
entries to BSP's ARAP after accepting the creditmemo.
| Ledger |
TransactionSet |
| CustomerCo |
|
|
|
transactionId: #66
transactionDate:2001/07/21
transactionDoc: #789
originalTransactionId: #4567
periode: july 2001
is posted: true
groupId: #999 |
|
transaction
Id |
entryId |
entry
Date |
entry
Doc |
entry
Journal
Type |
Account |
Dr/Cr |
Amount |
Party |
partys
Doc |
partys
User |
Product
Or
Service |
Quantity |
product
Measure |
settlement
method |
terms |
tax
type |
| #66 |
#11 |
2001/07/21 |
#25367 |
R |
Sale |
C |
1000 |
buyer
Company |
#PO33 |
owner |
Widgets |
5 |
litre |
|
|
#235 |
| #66 |
#12 |
2001/07/21 |
#25367 |
S |
AR |
D |
1100 |
buyer
Company |
#PO33 |
owner |
|
|
|
30days |
#44 |
|
| #66 |
#13 |
2001/07/21 |
#25367 |
B |
tax
Payable |
C |
100 |
tax
Agenscy3 |
#PO33 |
|
|
|
|
|
|
#235 |
| #66 |
#14 |
2001/07/25 |
#685 |
B |
inventory |
C |
400 |
|
#PO33 |
|
product 1 |
50 |
pieces |
|
|
|
| #66 |
#15 |
2001/07/25 |
#685 |
B |
inventory |
C |
435 |
|
#PO33 |
|
Widgets |
5 |
litre |
|
|
|
| #66 |
#16 |
2001/07/25 |
#685 |
R |
change in
inventory
(COGS) |
D |
835 |
|
#PO33 |
|
|
|
|
|
|
|
|
|
|
|
BSP's ARAP
| Ledger |
TransactionSet |
| CustomerCo |
|
|
|
transactionId: #70
transactionDate:2001/07/29
transactionDoc: #530
originalTransactionId: #5020
periode: july 2001
is posted: true
groupId: #999 |
|
transaction
Id |
entryId |
entry
Date |
entry
Doc |
entry
Journal
Type |
Account |
Dr/Cr |
Amount |
Party |
partys
Doc |
partys
User |
Product
Or
Service |
Quantity |
product
Measure |
settlement
method |
terms |
tax
type |
| #70 |
#33 |
2001/07/29 |
#78 |
R |
sale |
D |
100 |
Seller
Company |
#DM9 |
web
Store1 |
|
|
|
|
|
#235 |
| #70 |
#34 |
2001/07/29 |
#78 |
C |
AR |
C |
110 |
Seller
Company |
#DM9 |
web
Store1 |
|
|
|
30days |
#44 |
|
| #70 |
#35 |
2001/07/29 |
#78 |
B |
tax
Payable |
D |
10 |
tax
Agenscy3 |
#DM9 |
|
|
|
|
|
|
#235 |
|
|
|