Interprise Suite Community / Interprise Suite Community Forums / Questions and Comments About Features, Functions and Workarounds / Supplier

Deleting a duplicate invoice

Donna — Mon, 29 Mar 2010 13:34:12 GMT

Is there any way to delete or void a duplicate invoice from a supplier? We have had this issue both with an expense item and a purchase order with stock items and have been told by IS that there is no way to delete or void them, that we should just do a credit memo from the vendor and apply it to the duplicate invoice.

I don't see this as a very sound resolution accounting-wise.

Any ideas would be greatly appreciated.

Thanks,
Donna

Paying a bill for a service

Donna — Tue, 23 Feb 2010 06:35:42 GMT

The owner seems to be having difficulty paying bills for non-product related vendors, things like electric or water service.

He told me he's heard that IS isn't "terribly friendly in regards to this".

Could there be something he's just overlooking? I have no idea exactly what problem he's having, just that he can't get it to work properly.

Thanks,
Donna

Automated PO

John Bruns — Thu, 14 Jan 2010 07:58:16 GMT

We have played with the re-order points, min, max stock and 'usual Qty order' trying to get IS to order a specific quantity when the current inventory level drops below a set amount. EXAMPLE: Order QTY=6 of an item when stock level is <= 3 Looking for practical examples of how to use this automated feature. Hope someone has an idea.

Return Products to a Supplier

John Bruns — Thu, 15 Oct 2009 13:33:19 GMT

Since there is not a function to return items to a supplier (reverse PO) I was wondering how others do it.

We make an inventory adjustment OUT, then create a memo to the supplier for the $$ amount of the adjustment. Unfortunately, there is no paperwork to provide the supplier that shows what we did. John

Modify a GRN

Matthew White — Thu, 23 Jul 2009 12:09:00 GMT

It seems I get very little opportunity to modify a GRN. After creating the PO and Receving the goods, I can update the quantity, price, etc, but onec I hit save, the GRN seems to be Posted and I can't modify it again. Is there a way to turn off this posting somehow? ver 3.1

Can't find Inventory items?

fred_mccoy — Thu, 06 Aug 2009 10:05:51 GMT

Okay, anybody seen this one?

I have several hundred inventory items created and they show up perfectly both in the Inventory module and thru the test e-commerce site. However, I am now going in to create the purchase orders where we originally bought the latest shipments and it's giving me fits.

When I go to create either a Purchase Order or PO Requisition, I select the vendor and enter the appropriate header information, then proceed to the grid to enter the line items. Only problem is, it can't find any of them! Even when I hit F2 to display all items, none are found!

Did I accidentally turn something off somewhere, or has someone else run across this? I'm pulling my hair out, and after waiting over an hour on hold for tech support I gave up.

TIA,

Fred McCoy
Tech Gear Exchange
www.techgearexchange.com

Supplier Import

Matthew White — Sun, 19 Jul 2009 21:17:53 GMT

We are importing Suppliers using the standard Supplier Import but we get an error on Plymouth MN 55441, which is in the table. It seems we get an error on every city that is not the first one in the list when the zip code is the same for multiple cities. Is there any way around this?

Trying to Save/Post Supplier Bill

NAYLARD — Thu, 28 May 2009 17:09:58 GMT

I am getting this message for a bill i am trying to save. Everything matches and i cannot seem to figure out where the problem lies.

Message:

Posting returned the following message(s):
Debit and credit amounts not balanced

Any thoughts to where can I adjust or see what amounts are trying to balance

Thx

GL Being Duplicated When Posting a Supplier Bill Fix

BJ Dimes — Thu, 21 May 2009 15:42:59 GMT

There is a bug in the stored procedure that posts the supplier bills in the 5.3.1 Version. If you put in a supplier bill and on that bill there is anything in the 'Expense' tab, the general ledger activity for that expense will be duplicated (usually happens when you put in a regular expense bill or if you have other expenses on an invoice linked to a GRN). You will see two detail lines for that expense item be created as well as the accounts payable account be doubled in the general ledger.

A fix has been created. You will need to do the following to install this fix:

1) Download the following SQL Script from http://www.dimesoftinc.com/PostVendorBill.zip
2) Get everyone out of IS and the website (if you have one)
3) Open SQL Management Studio
4) Backup your SQL Database(s)
5) Unzip the zip file into a location your SQL Server can access
6) Open the SQL Script
7) Make sure you select your SQL Database(s)
8) Execute the SQL Script.

This script will replace your existing PostVendorBill Stored Procedure.

If you have run across any supplier bills that had GL Activity Duplicated, the only way to fix this is to do a Journal Entry between the duplicated account and the accounts payable account. This will bring everything back in line. If correct, your AP Aging should match whats on your Trail Balance.

Locating a Payment made to a supplier

Mlittman — Mon, 13 Apr 2009 18:45:13 GMT

Scenerio:

A supplier calls and gives you an Invoice number. You look it up and it shows that it was paid. However it does not show you the Check Number. What is the easiest way to locate the check number paid against a given invoice?

I created a SQL View that will display the information..but I am not a developer and do not use the SDK.. Is there any way through the user interface to add this view to a grid and be able to pull it up from a form or a menu? I was able to create a basic report but that takes too long when the supplier is on the phone.

You would think with the complexity of the CRM that this simple function..that seems a common place task..would already be in the system somewhere.

I have provided the SQL code below if anyone wants to create a simple plugin or grid. I think it would help a lot of end-users.

SQL:

SELECT SupplierPaymentDetailView.BillCode, SupplierPaymentDetailView.BillDate, SupplierBillTransactionHistoryView.InvoiceCode,
SupplierBillTransactionHistoryView.Reference, SupplierBillTransactionHistoryView.DatePaid, SupplierBillTransactionHistoryView.SupplierCode,
SupplierPaymentDetailView.AppliedAmount, SupplierPaymentDetailView.AmountPaid, SupplierPaymentDetailView.AppliedAmountRate,
SupplierPaymentDetailView.AmountPaidRate, SupplierPaymentDetailView.PayableCode, SupplierPaymentDetailView.Total
FROM SupplierPaymentDetailView INNER JOIN
SupplierBillTransactionHistoryView ON SupplierPaymentDetailView.BillCode = SupplierBillTransactionHistoryView.BillCode

Has anyone found a better solution?