How can we import multiple distribution for single line in AP invoice interface
e.g. invoice 'Invoice123' has single line as invoice_ line1, this line has two distributions like invoice_line_dist1 and invoice_line_dist2.
Solution :- To insert multiple distibution line against single invoice line while inserting data into AP_INVOICE_LINES_INTERFACE insert value for DISTRIBUTION_SET_NAME or DISTRIBUTION_SET_ID.
The only way to specify that an imported invoice line have more than one distribution (without matching to a PO) is to specify a distribution set in the row in AP_INVOICE_LINES_INTERFACE.Distribution_Set_Name or
AP_INVOICE_LINES_INTERFACE.Distribution_Set_ID. When the invoice is distributed (either by clicking on the Distributions button in the form or during validation) the system will create distributions based on the distribution set.
DISTRIBUTION SET NAME : Name of the Distribution Set. You define distribution sets in the Distribution Sets window. If you enter a distribution set name, during Payables Open Interface Import Payables automatically creates distributions for you based on the Distribution Set. If you enter a value here, you do not need to enter the corresponding value for DISTRIBUTION_SET_ID.
Note : Do not enter a value in this column if you are matching to a purchase order or if you provide an account.
Setup for Distribution Sets in Payable:
There are two types of distribution set in Payables.
Payables -> Setup -> Invoice -> Distribution Sets
Header part enter information for Below fields
Operating Unit :Vision Operations
Name : Full_dist_set
Description : Full Destribution Set (Not Mandetory)
Inactive On : Blank ( When we deactivate it it will have deactive date value)
Line
Here we can specify number of distribution lines we want to generate against single line. We can also mention % amount value which tell you how much percentage of amount we can devide Line amount for this line. we also need to enter data for account with all code combination.
Note: Sum of all % must be 100%. e.g. if we want to have 3 distribution line for single invoice line then we can specify three line with percentage 25% for first line second line 25% and for third line we must have 50% aginst each account code combination.
If you have Oracle Projects installed, you can associate a distribution with a project by entering project information on invoice distributions
Interface Table :
AP_INVOICE_INTERFACE_ALL
AP_INVOICE_INTERFACE_LINES_ALL
Base Table :
AP_INVOICES_ALL
AP_INVOICE_LINES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
e.g. invoice 'Invoice123' has single line as invoice_ line1, this line has two distributions like invoice_line_dist1 and invoice_line_dist2.
Solution :- To insert multiple distibution line against single invoice line while inserting data into AP_INVOICE_LINES_INTERFACE insert value for DISTRIBUTION_SET_NAME or DISTRIBUTION_SET_ID.
The only way to specify that an imported invoice line have more than one distribution (without matching to a PO) is to specify a distribution set in the row in AP_INVOICE_LINES_INTERFACE.Distribution_Set_Name or
AP_INVOICE_LINES_INTERFACE.Distribution_Set_ID. When the invoice is distributed (either by clicking on the Distributions button in the form or during validation) the system will create distributions based on the distribution set.
DISTRIBUTION_SET_ID: Internal identifier for the Distribution Set. If you enter a value for DISTRIBUTION_SET_NAME or DISTRIBUTION_SET_ID, then during import Payables automatically creates distributions for you based on the Distribution Set.
Note :Do not enter a value here if you are matching this line to a purchase order or if you enter an account.
| Validation: | This must be an existing, active value for AP_DISTRIBUTION_SETS.DISTRIBUTION_SET_ ID |
| Destination: | None |
DISTRIBUTION SET NAME : Name of the Distribution Set. You define distribution sets in the Distribution Sets window. If you enter a distribution set name, during Payables Open Interface Import Payables automatically creates distributions for you based on the Distribution Set. If you enter a value here, you do not need to enter the corresponding value for DISTRIBUTION_SET_ID.
Note : Do not enter a value in this column if you are matching to a purchase order or if you provide an account.
| Validation: | This must be an existing, active value for AP_DISTRIBUTION_SETS.DISTRIBUTION SET_NAME. If you are matching to a purchase order and you enter a value in this column, Payables Open Interface Import will reject the invoice. |
| Destination: | None |
Setup for Distribution Sets in Payable:
There are two types of distribution set in Payables.
- Full Distribution Sets
- Skeleton Distribution Sets
Payables -> Setup -> Invoice -> Distribution Sets
Header part enter information for Below fields
Operating Unit :Vision Operations
Name : Full_dist_set
Description : Full Destribution Set (Not Mandetory)
Inactive On : Blank ( When we deactivate it it will have deactive date value)
Line
Here we can specify number of distribution lines we want to generate against single line. We can also mention % amount value which tell you how much percentage of amount we can devide Line amount for this line. we also need to enter data for account with all code combination.
Note: Sum of all % must be 100%. e.g. if we want to have 3 distribution line for single invoice line then we can specify three line with percentage 25% for first line second line 25% and for third line we must have 50% aginst each account code combination.
| Num | % | Account | Description |
| 1 | 25 | 01-250-32061-000-000 | Distribution Account1 |
| 2 | 25 | 01-250-32061-000-001 | Distribution Account 2 |
| 3 | 50 | 01-250-32061-000-002 | Distibution Account 3 |
If you have Oracle Projects installed, you can associate a distribution with a project by entering project information on invoice distributions
Interface Table :
AP_INVOICE_INTERFACE_ALL
AP_INVOICE_INTERFACE_LINES_ALL
Base Table :
AP_INVOICES_ALL
AP_INVOICE_LINES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
Thanks for sharing this information.
ReplyDeleteHow can we import multiple distribution for single line in AP Invoice interface while matching with Purchase order.
Example:PO 1234 has one line at shipment level and 3 lines distribution level.
while creating PO Matched invoice through payabels invoice interface, invoice distribution account should distribute according to the PO Distribution account.
Invoice should be created with 3 distributions accounts.