fbpx

DEAR Inventory

1. Connect EzzyBills to DEAR System Cloud Inventory

2. Import Supplier Invoices into DEAR via EzzyBills (matching with a PO in DEAR)

After the connection is all set, you can start to upload supplier’s invoices to EzzyBills (via file upload, or email, or EzzyBills phone app).

1) EzzyBills will extract the PO number from the invoice, and look for the matching PO in DEAR with the same PO number.

If a match PO is not found in DEAR, please follow this link here to rectify

2) After the match PO is found in DEAR for the invoice, and the PO is Authorised, EzzyBills will  (screenshot below)

  • EzzyBills will match each Bill line with a PO line.
  • If a Bill line does not exist on the PO (such as a freight charge), then the line be added as an ‘Additional Costs’.
  • The Source document will then be attached to the PO.

3) You will then, in DEAR

  • Authorise” the invoice in DEAR
  • Once you receive the stocks in your warehouse, you then click “Add Stock Receiving“, then “Copy From Invoice“. Edit the lines to verify the received items and click Authorize.

If all stocks are received, then the PO status will change to “Received” by Dear automatically. The steps in 3 can be automated by EzzyBills. If you need this, please contact us at support@ezzydoc.com.

3. What if the matching PO is not found?

If the PO is not found in DEAR, or the status is not right (for example, the PO is already closed), we will return an error. See screenshot below.

You will also receive an automatic email

Please follow the instructions in this link to rectify the PO matching issue.

4. Let EzzyBills to create items in DEAR for you 

In order for EzzyBills to create items for you,  please change the setting below (Settings > Advanced Options > Default Item Code”).   

If this setting is empty, we

5. Case Studies of Processing Supplier Invoices to DEAR via EzzyBills

There are 3 common cases, before the bill is uploaded to EzzyBills

  1. The PO has not be created in DEAR.
  2. The PO has been created in DEAR,  but no lines were added to the PO
  3. The PO has been created in DEAR,  with lines (with “Blind Receipt” box ticked).

Case 1: PO has not be created. EzzyBills will create the PO from the invoice uploaded.

  • You email the invoice to #.purchase@ezzybills.com, where #@ezzybills.com is your normal EzzyBills upload email.
  • EzzyBills will process the invoice and create a Draft PO in DEAR, with lines. Attach the invoice file to the purchase.   Screenshot of the PO created by EzzyBills from an invoice

Note: you will then need to invoice & receive the PO in DEAR following a normal procedure:  click “Authorise” on the PO; Click “+ Invoicing & Receiving”.  Then click “Copy Remaining from Order” to fill the lines.  screenshot of invoicing & receiving a PO manually

Case 2: The PO has been created in DEAR,  but no lines were added to the PO yet

  • You upload the invoice (drag/drop, or email to EzzyBills).
  • EzzyBills will process the invoice, and find the PO in DEAR.

1) For the PO in DEAR, if the box for “Blind Receipt” is not checked,

  • the PO can not be invoiced because the PO status is not “authorised” (in DEAR, you cannot “authorise” an empty PO).   EzzyBills will give you an error: “Failed to create Receipt – Purchase task Order Status is not AUTHORISED”.

2) For the PO in DEAR, if the box for “Blind Receipt” is checked, it means that this purchase has no purchase order.

Case 3: The PO has been created in DEAR,  with lines

  • You upload the invoice (drag/drop, or email to EzzyBills).
  • EzzyBills will process the invoice, and find the PO in DEAR. Match the lines on the PO and create additional cost for extra lines on the invoice.  Create the invoice and attach the invoice file to the PO.  Screenshot