Difference between revisions of "Import Purchase Order"

Line 22: Line 22:
  
 
=====Import Purchase Order Record List=====
 
=====Import Purchase Order Record List=====
[[File:Import Purchase Order Record List.png|center|thumb|864x864px|Import Purchase Order Record List]]
+
[[File:Import Purchase Order Record List.png|center|864x864px]]
 
 
 
'''<br />Adding Import Purchase Order'''
 
'''<br />Adding Import Purchase Order'''
[[File:Adding Import Purchase Order.png|thumb|863x863px|Adding Import Purchase Order|center]]
+
[[File:Adding Import Purchase Order.png|center|863x863px]]
 +
<br />
  
 
*'''Adding Import Purchase Order Information'''
 
*'''Adding Import Purchase Order Information'''
Line 44: Line 44:
 
|3.[[Exchange Rate]]
 
|3.[[Exchange Rate]]
 
|•Current Exchange Rate on the Currency
 
|•Current Exchange Rate on the Currency
|•Number
+
|•Numeric
 
|-
 
|-
 
|4.Reference Number
 
|4.Reference Number
Line 58: Line 58:
 
|•Date
 
|•Date
 
|-
 
|-
|7.[[Budget]]
+
|7.Discount Type
|•Assigned Budget Center on the purchase transaction
 
|•Budget Center list provided in the Budget Center Maintenance Module
 
|-
 
|8.Discount Type
 
 
|•Type of Discount to be Applied on the Transaction
 
|•Type of Discount to be Applied on the Transaction
 
|•Discount Type (Amount/Percentage)
 
|•Discount Type (Amount/Percentage)
 
|-
 
|-
|9.[[Purchase Requisition]] Items
+
|8.[[Purchase Requisition]] Items
 
|•Purchase Requisition Item List that can be tag on the Import Purchase Order
 
|•Purchase Requisition Item List that can be tag on the Import Purchase Order
 
|•Purchase Requisition Items
 
|•Purchase Requisition Items
 
|-
 
|-
|10.[[Budget]]
+
|9.Notes
|•Budget to be used in the Transaction
 
|•Budget List
 
|-
 
|11.Notes
 
 
|•Other Remarks for the Transaction
 
|•Other Remarks for the Transaction
|•Text
+
|•Alphanumeric
 
|-
 
|-
|12.Item Name
+
|10.Item Name
 
|•Items to be purchased in the transaction
 
|•Items to be purchased in the transaction
|•Text
+
|•Alphanumeric
 
|-
 
|-
|13.[[Warehouse]]
+
|11.Description
 +
|•Description of the Item
 +
|•Alphanumeric
 +
|-
 +
|12.[[Warehouse]]
 
|•Warehouse where the items should be delivered
 
|•Warehouse where the items should be delivered
 
|•Warehouse
 
|•Warehouse
 
|-
 
|-
|14.[[Price List|Price]] <br />
+
|13.On Hand Qty
 +
|•On hand Quantity of an item in the Warehouse
 +
|•Numeric
 +
|-
 +
|14.[[Price List|Price]]  
 
|•Price of the items
 
|•Price of the items
|•Number
+
|•Numeric
 
|-
 
|-
 
|15.Quantity
 
|15.Quantity
 
|•Quantity of the items
 
|•Quantity of the items
|•Number
+
|•Numeric
 +
|-
 +
|16.UOM(Unit of Measure)
 +
|•Unit of Measure of an Item
 +
|•Unit of Measure assigned in the item under Item Master Maintenance Module
 +
|-
 +
|17.Discount
 +
|•Discount amount of an item
 +
|•Numeric(Auto-generated base from discount type)
 +
|-
 +
|18.Foreign Currency Amount
 +
|•Amount of an Item base from its currency and exchange rate.
 +
|•Numeric
 +
|-
 +
|19. Base Currency Amount
 +
|•Base Currency amount used in the transaction
 +
|•Numeric
 
|}Notes:
 
|}Notes:
  
Line 103: Line 119:
 
*Supplier should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
*Supplier should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Supplier]] Maintenance Module
 
**This can be seen in [[Supplier]] Maintenance Module
*Budget Center should on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Budget Center]] Maintenance Module
 
*<span style="color: rgb(51, 51, 51)">Budget should on '''ACTIVE''' status when using it upon creating or editing a transaction.</span>
 
**This can be seen in [[Budget]] Maintenance Module
 
 
*Warehouse should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
*Warehouse should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Warehouse]] Maintenance Module
 
**This can be seen in [[Warehouse]] Maintenance Module
*Project should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Project]] Maintenance Module.
 
 
*<span style="color: rgb(51, 51, 51)">For detailed steps on how to create a Import Purchase Order, you can visit the Import Purchase Order Job Aids which can be found <span>[[Import Purchase Order Aid|here]]</span></span>
 
*<span style="color: rgb(51, 51, 51)">For detailed steps on how to create a Import Purchase Order, you can visit the Import Purchase Order Job Aids which can be found <span>[[Import Purchase Order Aid|here]]</span></span>
  
 
=====Editing Import Purchase Order=====
 
=====Editing Import Purchase Order=====
[[File:Edit Import Purchase Order.png|center|thumb|863x863px|Editing Import Purchase Order]]
+
[[File:Edit Import Purchase Order.png|center|863x863px]]
 +
<br />
  
 
*'''Editing Import Purchase Order Information'''
 
*'''Editing Import Purchase Order Information'''
Line 133: Line 144:
 
|3.[[Exchange Rate]]
 
|3.[[Exchange Rate]]
 
|•Current Exchange Rate on the Currency
 
|•Current Exchange Rate on the Currency
|•Number
+
|•Numeric
 
|-
 
|-
 
|4.Reference Number
 
|4.Reference Number
Line 147: Line 158:
 
|•Date
 
|•Date
 
|-
 
|-
|7.[[Budget]]
+
|7.Discount Type
|•Assigned Budget Center on the purchase transaction
 
|•Budget Center list provided in the Budget Center Maintenance Module
 
|-
 
|8.Discount Type
 
 
|•Type of Discount to be Applied on the Transaction
 
|•Type of Discount to be Applied on the Transaction
 
|•Discount Type (Amount/Percentage)
 
|•Discount Type (Amount/Percentage)
 
|-
 
|-
|9.[[Purchase Requisition]] Items
+
|8.[[Purchase Requisition]] Items
 
|•Purchase Requisition Item List that can be tag on the Import Purchase Order
 
|•Purchase Requisition Item List that can be tag on the Import Purchase Order
 
|•Purchase Requisition Items
 
|•Purchase Requisition Items
 
|-
 
|-
|10.[[Budget]]
+
|9.Notes
|•Budget to be used in the Transaction
 
|•Budget List
 
|-
 
|11.Notes
 
 
|•Other Remarks for the Transaction
 
|•Other Remarks for the Transaction
|•Text
+
|•Alphanumeric
 
|-
 
|-
|12.Item Name
+
|10.Item Name
 
|•Items to be purchased in the transaction
 
|•Items to be purchased in the transaction
|•Text
+
|•Alphanumeric
 
|-
 
|-
|13.[[Warehouse]]
+
|11.Description
 +
|•Description of the Item
 +
|•Alphanumeric
 +
|-
 +
|12.[[Warehouse]]
 
|•Warehouse where the items should be delivered
 
|•Warehouse where the items should be delivered
 
|•Warehouse
 
|•Warehouse
 
|-
 
|-
|14.[[Price List|Price]] <br />
+
|13.On Hand Qty
 +
|•On hand Quantity of an item in the Warehouse
 +
|•Numeric
 +
|-
 +
|14.[[Price List|Price]]
 
|•Price of the items
 
|•Price of the items
|•Number
+
|•Numeric
 
|-
 
|-
 
|15.Quantity
 
|15.Quantity
 
|•Quantity of the items
 
|•Quantity of the items
|•Number
+
|•Numeric
 +
|-
 +
|16.[[Unit of Measure|UOM]](Unit of Measure)
 +
|•Unit of Measure of an Item
 +
|•Unit of Measure assigned in the item under Item Master Maintenance Module
 +
|-
 +
|17.Discount
 +
|•Discount amount of an item
 +
|•Numeric(Auto-generated base from discount type)
 +
|-
 +
|18.Foreign Currency Amount
 +
|•Amount of an Item base from its currency and exchange rate.
 +
|•Numeric
 +
|-
 +
|19. Base Currency Amount
 +
|•Base Currency amount used in the transaction
 +
|•Numeric
 
|}Notes:
 
|}Notes:
 
Notes:
 
  
 
*The Import Purchase Order will be automatically set to '''PARTIAL''' when:
 
*The Import Purchase Order will be automatically set to '''PARTIAL''' when:
Line 197: Line 222:
 
*Supplier should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
*Supplier should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Supplier]] Maintenance Module.
 
**This can be seen in [[Supplier]] Maintenance Module.
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
 
 
*Budget should on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Budget]] Maintenance Module.
 
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
 
*Budget Center should on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Budget Center]] Maintenance Module
 
 
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
 
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
  
 
*Warehouse should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
*Warehouse should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Warehouse]] Maintenance Module
 
**This can be seen in [[Warehouse]] Maintenance Module
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
 
 
*Project should be on '''ACTIVE''' status when using it upon creating or editing a transaction.
 
**This can be seen in [[Project]] Maintenance Module
 
 
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
 
**Past Transactions with '''INACTIVE''' status prior to its deactivation can still be used.
  
Line 233: Line 247:
  
 
=====Import Purchase Order View Record=====
 
=====Import Purchase Order View Record=====
[[File:Import Purchase Order View Record.png|center|thumb|Import Purchase Order View Record]]
+
[[File:Import Purchase Order View Record.png|center|864x864px]]
 +
 
 +
 
 
Notes:
 
Notes:
  
Line 251: Line 267:
 
|-
 
|-
 
|Maintenance
 
|Maintenance
|[[Budget]]<nowiki> | </nowiki>[[Budget Center]]<nowiki> | </nowiki>[[Currency]]<nowiki> | </nowiki>[[Exchange Rate]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Price List]]<nowiki> | </nowiki>[[Project]]<nowiki> | </nowiki>[[Supplier]]<nowiki> | </nowiki>[[Warehouse]]
+
|[[Currency]]<nowiki> | </nowiki>[[Exchange Rate]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Price List]]<nowiki> | </nowiki>[[Supplier]]<nowiki> | </nowiki>[[Unit of Measure]]<nowiki> | </nowiki>[[Warehouse]]
 
|-
 
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
Line 262: Line 278:
 
|-
 
|-
 
|Maintenance Aids
 
|Maintenance Aids
|[[Budget Aids]]<nowiki> | </nowiki>[[Budget Center Aids]]<nowiki> | </nowiki>[[Currency Aids]]<nowiki> | </nowiki>[[Exchange Rate Aids]]<nowiki> | </nowiki>[[Item Master Aids]]<nowiki> | </nowiki>[[Price List Aids]]<nowiki> | </nowiki>[[Project Aids]]<nowiki> | </nowiki>[[Supplier Aids]]<nowiki> | </nowiki>[[Warehouse Aids]]
+
|[[Currency Aids]]<nowiki> | </nowiki>[[Exchange Rate Aids]]<nowiki> | </nowiki>[[Item Master Aids]]<nowiki> | </nowiki>[[Price List Aids]]<nowiki> | </nowiki>[[Supplier Aids]]<nowiki> | </nowiki>[[Unit of Measure Aids]]<nowiki> | </nowiki>[[Warehouse Aids]]
|-
 
|Others
 
|[[Budget Process]]
 
 
|}
 
|}

Revision as of 20:28, 6 September 2021

Import Purchase Order

This module allows the user to create an order to buy items on their supplier.

Requirements before using Import Purchase Order
Import Purchase Order Record List


Adding Import Purchase Order


  • Adding Import Purchase Order Information
Field Description Expected Values
1.Supplier •Name of Supplier •Supplier List provided in the Supplier Maintenance Module
2.Currency •Currency Applied for the Transaction •Currency List provided in the Currency Maintenance Module
3.Exchange Rate •Current Exchange Rate on the Currency •Numeric
4.Reference Number •Reference Number for the Transaction •Alphanumeric
5.Transaction Date •Date when the transaction is created •Date
6.Expected Deliver •Date of the Delivery •Date
7.Discount Type •Type of Discount to be Applied on the Transaction •Discount Type (Amount/Percentage)
8.Purchase Requisition Items •Purchase Requisition Item List that can be tag on the Import Purchase Order •Purchase Requisition Items
9.Notes •Other Remarks for the Transaction •Alphanumeric
10.Item Name •Items to be purchased in the transaction •Alphanumeric
11.Description •Description of the Item •Alphanumeric
12.Warehouse •Warehouse where the items should be delivered •Warehouse
13.On Hand Qty •On hand Quantity of an item in the Warehouse •Numeric
14.Price •Price of the items •Numeric
15.Quantity •Quantity of the items •Numeric
16.UOM(Unit of Measure) •Unit of Measure of an Item •Unit of Measure assigned in the item under Item Master Maintenance Module
17.Discount •Discount amount of an item •Numeric(Auto-generated base from discount type)
18.Foreign Currency Amount •Amount of an Item base from its currency and exchange rate. •Numeric
19. Base Currency Amount •Base Currency amount used in the transaction •Numeric

Notes:

  • The Import Purchase Order will be automatically set to PARTIAL when:
    • When tagging it to Purchase Receipt where in the quantity available in the warehouse is less than to the intended order
  • Item should be on ACTIVE status when using it upon creating or editing a transaction.
  • Supplier should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Supplier Maintenance Module
  • Warehouse should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Warehouse Maintenance Module
  • For detailed steps on how to create a Import Purchase Order, you can visit the Import Purchase Order Job Aids which can be found here
Editing Import Purchase Order


  • Editing Import Purchase Order Information
Field Description Expected Values
1.Supplier •Name of Supplier •Supplier List provided in the Supplier Maintenance Module
2.Currency •Currency Applied for the Transaction •Currency List provided in the Currency Maintenance Module
3.Exchange Rate •Current Exchange Rate on the Currency •Numeric
4.Reference Number •Reference Number for the Transaction •Alphanumeric
5.Transaction Date •Date when the transaction is created •Date
6.Expected Deliver •Date of the Delivery •Date
7.Discount Type •Type of Discount to be Applied on the Transaction •Discount Type (Amount/Percentage)
8.Purchase Requisition Items •Purchase Requisition Item List that can be tag on the Import Purchase Order •Purchase Requisition Items
9.Notes •Other Remarks for the Transaction •Alphanumeric
10.Item Name •Items to be purchased in the transaction •Alphanumeric
11.Description •Description of the Item •Alphanumeric
12.Warehouse •Warehouse where the items should be delivered •Warehouse
13.On Hand Qty •On hand Quantity of an item in the Warehouse •Numeric
14.Price •Price of the items •Numeric
15.Quantity •Quantity of the items •Numeric
16.UOM(Unit of Measure) •Unit of Measure of an Item •Unit of Measure assigned in the item under Item Master Maintenance Module
17.Discount •Discount amount of an item •Numeric(Auto-generated base from discount type)
18.Foreign Currency Amount •Amount of an Item base from its currency and exchange rate. •Numeric
19. Base Currency Amount •Base Currency amount used in the transaction •Numeric

Notes:

  • The Import Purchase Order will be automatically set to PARTIAL when:
  • The user can only edit the Import Purchase Order Entry if the status of the record is on PENDING status.
  • Item should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Item Master Maintenance Module.
    • Past Transactions with INACTIVE status prior to its deactivation can still be used.
  • Supplier should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Supplier Maintenance Module.
    • Past Transactions with INACTIVE status prior to its deactivation can still be used.
  • Warehouse should be on ACTIVE status when using it upon creating or editing a transaction.
    • This can be seen in Warehouse Maintenance Module
    • Past Transactions with INACTIVE status prior to its deactivation can still be used.
  • For detailed steps on how to edit an Import Purchase Order, you can visit the Import Purchase Order Job Aids which can be found here
Import Purchase Order Options
File:Import Purchase Order Options.png
Import Purchase Order Options
  • For detailed steps on how to export an Import Purchase Order, you can visit the Import Purchase Order Job Aids which can be found here
Import Purchase Order Record Options
File:Import Purchase Order Record Options.png
Import Purchase Order Record Options

Notes:

  • The user can only cancel the record if the Transaction is still on PENDING status.
  • The user can Tag as Complete the record if it is on PARTIAL status
  • For detailed steps on how to view, edit, print and Cancel an Import Purchase Order, you can visit the Import Purchase Order Job Aids which can be found here
Import Purchase Order View Record


Notes:

  • The user can edit the details of the record while viewing it.
  • For detailed steps on how to view an Import Purchase Order, you can visit the Import Purchase Order Job Aids which can be found here
Categories:
Modules
Purchase Purchase | Import Purchase Order | Purchase Requisition | Purchase Receipt
Financials Accounts Payable
Maintenance Currency | Exchange Rate | Item Master | Price List | Supplier | Unit of Measure | Warehouse
Job Aid Modules
Purchase Aids Import Purchase Order Aid | Purchase Requisition Aid | Purchase Receipt Aid
Financials Aids Accounts Payable Aids
Maintenance Aids Currency Aids | Exchange Rate Aids | Item Master Aids | Price List Aids | Supplier Aids | Unit of Measure Aids | Warehouse Aids