Sage 100

Created a manual check import in v2019.  I want to auto assign the next WIRE number, not the next check number.  The check type "W" is being imported prior to assigning the next number (below) but the next CHECK number is being assigned.

Any thoughts where I veered off the path or is this a WAD, not a bug a boo???

Thanks in advance.



------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Remove the CheckNo field from the import.  Move the WireTransferNo field to the former position of the CheckNo field.  Change the Operand of the WireTransferNo field to Next.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Thanks for the response, but I am not seeing it.  The WireTransferNo field is the comment field where you enter the wire confirmation.  If you remove the CheckNo field entirely, the import fails due to missing check number.

It appears that there is some BOI perform logic is missing on payment type to differentiate between checks and wires.

Also, after importing, then going into manual check entry, the wire transfer number information field is missing.  It does appear if you click on the details tab, then go back to the header tab.

Entered a manual wire transfer and then looked at the manual Check Header table via DFDM, all fields appear populated equally between the VI payment and the manual entry payment.



​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-24-2019 12:24
From: Doug Higgs
Subject: Manual Check Import - v2019

Remove the CheckNo field from the import.  Move the WireTransferNo field to the former position of the CheckNo field.  Change the Operand of the WireTransferNo field to Next.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

------Original Message------

Thanks for the response, but I am not seeing it.  The WireTransferNo field is the comment field where you enter the wire confirmation.  If you remove the CheckNo field entirely, the import fails due to missing check number.

It appears that there is some BOI perform logic is missing on payment type to differentiate between checks and wires.

Also, after importing, then going into manual check entry, the wire transfer number information field is missing.  It does appear if you click on the details tab, then go back to the header tab.

Entered a manual wire transfer and then looked at the manual Check Header table via DFDM, all fields appear populated equally between the VI payment and the manual entry payment.



​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Nope, that is the wire confirmation comment field.  I am thinking there is logic missing.

@Alnoor Cassim ?
@David Speck II ?
@Kevin Moyes ?
​​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-24-2019 13:10
From: Doug Higgs
Subject: Manual Check Import - v2019

There is a wiretransnumber field in the manual check entry header.

Original Message------

Thanks for the response, but I am not seeing it.  The WireTransferNo field is the comment field where you enter the wire confirmation.  If you remove the CheckNo field entirely, the import fails due to missing check number.

It appears that there is some BOI perform logic is missing on payment type to differentiate between checks and wires.

Also, after importing, then going into manual check entry, the wire transfer number information field is missing.  It does appear if you click on the details tab, then go back to the header tab.

Entered a manual wire transfer and then looked at the manual Check Header table via DFDM, all fields appear populated equally between the VI payment and the manual entry payment.



​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Just a WAG but try moving the H.WireTransferNo field up with the Header records?

------------------------------
Therese Logeais
Technology Integrators
------------------------------

Original Message:
Sent: 04-24-2019 13:37
From: Jeff Schwenk
Subject: Manual Check Import - v2019

Nope, that is the wire confirmation comment field.  I am thinking there is logic missing.

@Alnoor Cassim ?
@David Speck II ?
@Kevin Moyes ?
​​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 04-24-2019 13:10
From: Doug Higgs
Subject: Manual Check Import - v2019

There is a wiretransnumber field in the manual check entry header.

Original Message------

Thanks for the response, but I am not seeing it.  The WireTransferNo field is the comment field where you enter the wire confirmation.  If you remove the CheckNo field entirely, the import fails due to missing check number.

It appears that there is some BOI perform logic is missing on payment type to differentiate between checks and wires.

Also, after importing, then going into manual check entry, the wire transfer number information field is missing.  It does appear if you click on the details tab, then go back to the header tab.

Entered a manual wire transfer and then looked at the manual Check Header table via DFDM, all fields appear populated equally between the VI payment and the manual entry payment.



​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

The value is in the CheckNo field... but when entered manually you don't click Next.  As soon as I click the Wire Transfer option it automatically fills it in.  I wonder if the functionality is built into the UI object instead of the business object (which would make it unavailable for VI...)?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 04-24-2019 13:37
From: Jeff Schwenk
Subject: Manual Check Import - v2019

Nope, that is the wire confirmation comment field.  I am thinking there is logic missing.

@Alnoor Cassim ?
@David Speck II ?
@Kevin Moyes ?
​​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 04-24-2019 13:10
From: Doug Higgs
Subject: Manual Check Import - v2019

There is a wiretransnumber field in the manual check entry header.

Original Message------

Thanks for the response, but I am not seeing it.  The WireTransferNo field is the comment field where you enter the wire confirmation.  If you remove the CheckNo field entirely, the import fails due to missing check number.

It appears that there is some BOI perform logic is missing on payment type to differentiate between checks and wires.

Also, after importing, then going into manual check entry, the wire transfer number information field is missing.  It does appear if you click on the details tab, then go back to the header tab.

Entered a manual wire transfer and then looked at the manual Check Header table via DFDM, all fields appear populated equally between the VI payment and the manual entry payment.



​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

@Therese Logeais - The WireTransferNo​​ field is just a comment field for the wire confirmation number.  @Doug Higgs had suggested that as well.  @kevinmoyes is probably on the right path.  Something is missing in the VI code that is present when you manually enter the payment.  Similar to the missing VI "is this a check reversal"  and "do you wish to recall invoices" flags when you need to reverse a bunch of AP checks issued against the incorrect bank account.
​
​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-24-2019 15:03
From: Kevin Moyes
Subject: Manual Check Import - v2019

The value is in the CheckNo field... but when entered manually you don't click Next.  As soon as I click the Wire Transfer option it automatically fills it in.  I wonder if the functionality is built into the UI object instead of the business object (which would make it unavailable for VI...)?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 04-24-2019 13:37
From: Jeff Schwenk
Subject: Manual Check Import - v2019

Nope, that is the wire confirmation comment field.  I am thinking there is logic missing.

@Alnoor Cassim ?
@David Speck II ?
@Kevin Moyes ?
​​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 04-24-2019 13:10
From: Doug Higgs
Subject: Manual Check Import - v2019

There is a wiretransnumber field in the manual check entry header.

Original Message------

Thanks for the response, but I am not seeing it.  The WireTransferNo field is the comment field where you enter the wire confirmation.  If you remove the CheckNo field entirely, the import fails due to missing check number.

It appears that there is some BOI perform logic is missing on payment type to differentiate between checks and wires.

Also, after importing, then going into manual check entry, the wire transfer number information field is missing.  It does appear if you click on the details tab, then go back to the header tab.

Entered a manual wire transfer and then looked at the manual Check Header table via DFDM, all fields appear populated equally between the VI payment and the manual entry payment.



​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Will it allow you to override the check number when using a check type of W when importing?  Can you import a check number with "W" as the first character?

------------------------------
alan niergarth
Velosio LLC
------------------------------

Where is the next wire transfer number even stored?? Where is Sage getting it from when Wire Transfer is selected? I'm wondering about Alan's question. What if you don't include check number in your import (guessing it will fail)?​​

------------------------------
Therese Logeais
Technology Integrators
------------------------------

Original Message:
Sent: 04-24-2019 15:17
From: alan niergarth
Subject: Manual Check Import - v2019

Will it allow you to override the check number when using a check type of W when importing?  Can you import a check number with "W" as the first character?

------------------------------
alan niergarth
Velosio LLC
------------------------------

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 04-24-2019 15:26
From: Therese Logeais
Subject: Manual Check Import - v2019

Where is the next wire transfer number even stored?? Where is Sage getting it from when Wire Transfer is selected? I'm wondering about Alan's question. What if you don't include check number in your import (guessing it will fail)?​​

------------------------------
Therese Logeais
Technology Integrators
------------------------------


Original Message:
Sent: 04-24-2019 15:17
From: alan niergarth
Subject: Manual Check Import - v2019

Will it allow you to override the check number when using a check type of W when importing?  Can you import a check number with "W" as the first character?

------------------------------
alan niergarth
Velosio LLC

If you don't include the check number field, import fails. I would guess that you can assign the check # which includes a W but now you are having to keep track of the sequence.  Burning up a check number would be just as easy.  If they really want to use the wire method, client can upload VIA AP invoice entry, update, then pay via manual check entry.  All of these options are 90% solutions.  I will send issues to Sage and hope for a fix in a couple of years......
​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-24-2019 15:38
From: Kevin Moyes
Subject: Manual Check Import - v2019



------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 04-24-2019 15:26
From: Therese Logeais
Subject: Manual Check Import - v2019

Where is the next wire transfer number even stored?? Where is Sage getting it from when Wire Transfer is selected? I'm wondering about Alan's question. What if you don't include check number in your import (guessing it will fail)?​​

------------------------------
Therese Logeais
Technology Integrators


Original Message:
Sent: 04-24-2019 15:17
From: alan niergarth
Subject: Manual Check Import - v2019

Will it allow you to override the check number when using a check type of W when importing?  Can you import a check number with "W" as the first character?

------------------------------
alan niergarth
Velosio LLC

------Original Message------

If you don't include the check number field, import fails. I would guess that you can assign the check # which includes a W but now you are having to keep track of the sequence.  Burning up a check number would be just as easy.  If they really want to use the wire method, client can upload VIA AP invoice entry, update, then pay via manual check entry.  All of these options are 90% solutions.  I will send issues to Sage and hope for a fix in a couple of years......
​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------
​

You da man, Jim!

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-24-2019 19:41
From: Jim Woodhead
Subject: Manual Check Import - v2019

@Jeffschwenk

I have the VI perform logic to get the next W number and increment the number.   PM if  you are interested.

Get Outlook for iOSo

 

Original Message------

If you don't include the check number field, import fails. I would guess that you can assign the check # which includes a W but now you are having to keep track of the sequence.  Burning up a check number would be just as easy.  If they really want to use the wire method, client can upload VIA AP invoice entry, update, then pay via manual check entry.  All of these options are 90% solutions.  I will send issues to Sage and hope for a fix in a couple of years......
​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------
​

Hi Jim,

I was wondering if you still have available the VI perform logic operation to determine the next W number and increment it. I'd appreciate any information you can provide.

Thank you!

------------------------------
Mihai Patrutiu
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 04-24-2019 19:41
From: Jim Woodhead
Subject: Manual Check Import - v2019

@Jeffschwenk

I have the VI perform logic to get the next W number and increment the number.   PM if  you are interested.

Get Outlook for iOSo

 

Original Message------

If you don't include the check number field, import fails. I would guess that you can assign the check # which includes a W but now you are having to keep track of the sequence.  Burning up a check number would be just as easy.  If they really want to use the wire method, client can upload VIA AP invoice entry, update, then pay via manual check entry.  All of these options are 90% solutions.  I will send issues to Sage and hope for a fix in a couple of years......
​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------
​