Get Connected!

Come and join our community. Expand your network and get to know new people!

Gary Harrison replied to the topic 'Receiving Inventory' in the forum. 1 month ago

Hi David,

We have began adding the ability to void "saved" GRN's. This should be available in early May. Thank you for the great suggestion!  

Read More...

David Nelson replied to the topic 'Receiving Inventory' in the forum. 1 month ago

Gary,

Woops.  I left one important word out of my previous post...unposted...let me clarify...

We need an unposted GRN VOID function.   (not delete GRN, not void GRN after posting)   From my understanding, an unposed GRN does not impacted any of the areas you listed in your previous post.

If is easy to accidentally create an unwanted unposted GRN from a PO.  Once created and not posted, you are stuck in a box.  At this point you are forced to post the unwanted GRN and then go through many undesired steps as outlined in my previous post. 

My customers do this on some regular basis, and I am the who has to go through the process of cleaning it up.  So that is why I'm plugged into this issue.  :)

David Nelson
Connected Business Channel Partner
Dynamic Enterprise Technologies Inc
Seattle Washington USA

Read More...

David Nelson replied to the topic 'Regarding Connection Between Main server and Client Server' in the forum. 1 month ago

Jassim,

The basics are:
- Make sure your SQL server allows connections from other computers
- Make sure SQL server security is setup so the client computers can connect to SQL server
- In each client computer, in Connected Business, at the login prompt, create the connection to your database

It is somewhat hard to guide someone through the process via a message board as there are a number of pieces that must fix together.  If you want to join into a web meeting it would be easier.  If you want to schedule a web meeting with me, you can get my contact information from my web site, send an email, then we can schedule some time to meet.

David Nelson
www.dynenttech.com
Dynamic Enterprise Technologies Inc
Connected Business Channel Partner
Seattle Washington USA

Read More...

Najeeb siddiqui replied to the topic 'Local Telephone Formats / Dates / Times' in the forum. 1 month ago

Dear Gary,

As per David , can this be implemented, also if this will settle date issue, will it fix the Time Issue as well.

The Other part where you have suggested changing the country Format Settings, Please note that I have changed that multiple times but the format does not replicate across the CB System.

Kindly advise 

Thanks 

Read More...

David Nelson replied to the topic 'Local Telephone Formats / Dates / Times' in the forum. 1 month ago

Najeeb,
 
I have a Canadian customer (not hosted by CB) using DD/MM/YYYY so I know it can work.
 
Are you running the CB client on your local workstation or on the CB hosted server?
 
At a minimum, the publicly visible reports can be changed to report the date in DD/MM/YYYY format.
 
If using RDP, your server login should be able to be changed so the format is DD/MM/YYYY (as date format is per login).
 
Worst case, you can host CB on your own server like Microsoft Azure so you can be in full control of the date format.
 
If you want to work with me and try to get the issue worked out, you can go to our web site for our contact information.
 
David Nelson
www.dynenttech.com
Dynamic Enterprise Technologies Inc
Connected Business Channel Partner
Seattle | Portland | Los Angeles

Read More...

David Nelson replied to the topic 'Local Telephone Formats / Dates / Times' in the forum. 1 month ago

Gary,
 
I studied the link you provided and otherwise looked into the issue.
 
Your statement “the date format is determined by the date format of the server” I think is technically incorrect.  SQL server doesn’t have a date format per se,as dates are not stored as strings on the database.  What SQL server does have is a “string to date” and “date to string” default conversion format. 
 
If an application is passing dates to SQL server as strings, it can cause problems on the SQL server side converting the strings to dates with different collations.  It is advised to not to pass dates in string format to SQL server for this reason.  If you send dates to SQL server using a date datatype, you are not going to have an issue with collation (because no string
to date data conversion takes place on the SQL server side).
 
You can read about the issue here and it explains how CB could be adjusted to not be dependent on SQL server collation:
 
stackoverflow.com/questions/27011693/whi...ault-datetime-format
 
If you must send dates to SQL server in string format,you could check the collation of the SQL server you are connected to, and the date format of the client, then format the dates in the correct format in the string you send to SQL server so the “string to date” conversion on the server side will work as expected.  In this way it would make the client date format and SQL server "string to date" format independent and the issue would be resolved.
 
David Nelson
Dynamic Enterprise Technologies Inc
Connected Business Channel Partner
Seattle | Portland | Los Angeles

Read More...

Gary Harrison replied to the topic 'Receiving Inventory' in the forum. 1 month ago

Hi David,

There are numerous reasons why we cannot just delete a GRN.

A lot of things happen when you post a GRN such as…

1) Post the inventory stock table that these products are now available for sale and what unconfirmed costs to use.
2) Convert any pending “reservations” into allocations

We also have to consider actions that can take place immediately after posting such as…

1) The items on the GRN may have been invoiced and the unconfirmed costs used. This is especially tricky with FIFO / LIFO costing is used. If we delete the GRN costing will be off.
2) There is a highly likelihood that deleting a GRN would cause an item to be in the negative numbers. This would be a big issue for companies that have this configuration option turned on.
3) The received quantities may have new sales that have been allocated. 
4) The items could be part of an assembly and the received quantities used as part of a new build.
5) The item might have had serial / lot numbers – and all the downline processes from there.

We simply just can’t allow a user to “void” at anytime as all of these types of transactions would be affected causing a lot of issues.

We wish that we could add a “void” button here, but there are too many other issues this would cause for the end user. What we did do in version 19 is add the ability to “save” a GRN so users can implement a workflow to first save – then return to it when they are sure they want to post.  See video of that here…

vimeo.com/408224129

Read More...

Gary Harrison replied to the topic 'Local Telephone Formats / Dates / Times' in the forum. 1 month ago

Hi Najeeb,

1) Unfortunately the date format is determined by the date format of the server. This is due to sql collation. Our cloud uses the SQL collation of SQL_Latin1_General_CP1_CI_AS.
docs.microsoft.com/en-us/sql/relational-...ver-level-collations

2) You can set this under system manager->setup->country

Read More...

Jassim Karim created a new topic ' Regarding Connection Between Main server and Client Server' in the forum. 1 month ago

How do i connect between my main Server and Client Server computers. I want to connect 3-4 Computers to my main server. Our Computers are connected through Lan cables.

Can someone guide me how to connect my main server with my client computers.

Regards,
Jassim karim

Read More...

Najeeb siddiqui created a new topic ' Local Telephone Formats / Dates / Times' in the forum. 1 month ago

Dear Fellow CBer's

We have recently Started using CB as a hosted Application by Cb ,

I am trying to see if someone else is facing the same issue or have a Practicle solution for This Situation.

1) Our Dates and Times are all displayed as The server Dates and Times ( even Formatting ) , When we enter dates it uses the Server Format , ( MM-DD-YYYY) where as we use the international Standard (DD-MM-YYYY) or even the long date as in ( Thursday 1st Of November , 2020 ) How do we sort this ( it is a major issue since time and Billing are all required to be standard from our Ministries and Govt Offices )

2) The telephone / Fax / Mobile Formats are still showing up in a wierd way even when these settings have been changed from the counrty Settins Etc , .... +(XX) XX XXX XX INstead of (+XXX ) XXXX XXXX

please Advise so i can fix this

Thansk

Read More...

David Nelson replied to the topic 'Receiving Inventory' in the forum. 1 month ago

Gary,

The problem is with an accidentally or incorrectly created GRN from a PO. Once the GRN is created (and not yet posted), you a have a big problem on your hands. There is no VOID function available for the GRN.

The only way out of this situation is a painful process as noted in Michelle's post. You must post the unwanted GRN, create an unwanted Bill, post the unwanted Bill, create an unwanted return, post the unwanted return, create an unwanted debit memo, and post the unwanted debit memo. Not to mention the fact that your PO is now completed and you can't create a new and proper GRN from it when you are ready, so you also have to create a new PO.

We need a GRN VOID function.

The warehouse can be a fast paced place and it is easy for the warehouse staff to click the wrong button.

Given that we are forced to post unwanted GRNs, to keep the records as clean as possible, when I have a large GRN in this situation, I set the qty received to zero for all line items except he first line item, then set the first line item quantity received to 1.. This minimizes the items, the value, and the quantity of all the unwanted transactions you must process to get out of the situation.

David Nelson
Dynamic Enterprise Technologies Inc
Connected Business Channel Partner
Seattle | Portland | Los Angeles

Read More...

Gary Harrison replied to the topic 'Receiving Inventory' in the forum. 1 month ago

Hi,
Since the GRN is posting the “unconfirmed cost” which could be used as the costs in transactions (and then posted to your financials), we can’t simply “delete” the transactions as that would go against generally accepted accounting principles (GAAP). Best bet it void. Also, note that you can use inventory adjustments to zero out any mistakes that were made. Just be careful to use the same exact item cost...

Read More...

Najeeb siddiqui replied to the topic 'Receiving Inventory' in the forum. 1 month ago

is this still valid or has bit been updated in the latest versions ?

Thanks

Read More...

Alison replied to the topic 'Re sorting items on website in CB 19.0.6921' in the forum. 1 month ago

Just noticed that this is fixed in version 19.2

Read More...

Cynthia Nelson shared a photo. 2 months ago

Kamagra 100mg Tablet is a generic medicine used to treat erectile dysfunction in men. It performs by improving blood circulation to the male organ... Show more

Kamagra 100mg Tablet is a generic medicine used to treat erectile dysfunction in men. It performs by improving blood circulation to the male organ. This assists men to achieve or keep an erection. It belongs to a group of medications known as PDE-5 inhibitors. See more details, at: http://www.genericviagraworld.com/kamagra.aspx
David Nelson replied to the topic 'Configuring CB 19.2 in LAN environment' in the forum. 3 months ago

Most likely the problem is the SQL server on Machine1 is not configured to allow connections from other computers on the network (this is the default). Or it could be the firewall on Machine1 is blocking the SQL server port. My company would be happy to assist you in getting the workstations up and running. If you need our assistance, please email This email address is being protected from spambots. You need JavaScript enabled to view it. with your request and we can schedule time to assist.

David Nelson
CB Channel Partner
Dynamic Enterprise Technologies Inc
www.dynenttech.com

Read More...

Rudy Pancaro replied to the topic 'Configuring CB 19.2 in LAN environment' in the forum. 3 months ago

Hello,

Welcome to the CB Forum. There can be a number of different environmental factors and firewall configuration changes that need to be changed in order to ensure that your client machines reliably connect to your server for the CB Community Edition.

I would suggest opening a support case with Connected Business directly to request installation services. The qualified team at Connected Business can then review configuration and recommend any necessary adjustments to ensure the program works correctly.

If you need any further assistance, please back out here on the forum for additional support.

Thanks.

- Rudy
CB Enterprise Partner

Read More...

Register

Remember Me

Videos

View all videos

Events

Sorry, we currently have no events.
View All Events