Najeeb Siddiqui wrote: Dear Team CB,
Is there a way to issue items to a customer on a trial Basis (Client Approval / Client Check on Site ), let us say that the customer wants to check the item Specs at the installation site or wants to make sure that it is a 100% fit in terms of installation at his/her Property and wants to take the items out of our store. Is there a way to issue a document to acknowledge this.
We usually create a Hand Written Note for this purpose, is there a way to do that in CB . in Certain software this function is called ( Material Supply for Approval )
Najeeb Siddiqui wrote: When editing / adding the Payment terms, the system issues a start date ( Current Date ) can this be changed to a previous date if not why so?
Najeeb Siddiqui wrote: What do we need to do to upgrade the payment terms of existing customers from let's say 45Days to 30 days? I have added a couple of different payment terms but they are not shown in the individual customer information ... only the ones which were there when the customer was created are shown in the drop-down menu ..
POINT 1:
You can have multiple suppliers per item. In the item, there is a Costing tab. In that tab, you can list all of the possible suppliers for an item.
POINT 2:
In Supplier preferences, there is an option "Filter items according to suppler". If you turn this off, on a Purchase Order, the list of items will not be limited to the current supplier.
David Nelson
Dynamic Enterprise Technologies Inc
Seattle | Portland | Los Angeles
www.dynenttech.com
Read More...
Najeeb Siddiqui wrote: Dear CB Community,
What Format would be the best choice, Usually we receive these PO's in PDF format Ranging From 250Kb to 350 KB depending on different factors. My concerns are as follows
Najeeb Siddiqui wrote: Dear CB Community,
1) Can We limit the file sizes to a certain Size so users don't accidentally attach large files?
Najeeb Siddiqui wrote: Dear CB Community,
2) Is there a place within CB where I can check my Attached File details and DB Size to check for any irregularities?
Najeeb Siddiqui wrote: Dear CB Community,
4) is there any automated or efficient way of doing this?
Najeeb Siddiqui wrote: Dear CB Community,
3) Are there any considerations i need to keep in mind while my users attach files ?
David Nelson is friends with Bill Dimes
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...
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,
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...
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,
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...
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...
(Free) Welcome to the Connected Business implementation and setup course! In this course we will walk you through the various steps you need to take in order to configure your copy of Connected Business for your company. This course is made up of 11 Lessons. This course is not designed to substitute an experienced implementation professional and we highly recommend that you work with one of our partners through this process to guide you to success. You can start the course by clicking the video screenshot on the first course on the right (in the course list). Connected Business is a...
This course is divided into the following lessons: (1) Customer Detail Form, (2) Process Sales Orders, (3) Creating Invoices, (4) Shipping Orders, (5) Entering Payments, (6) Processing Returns and Refunds, (7) Manage Customer Credit, (8) Working with Gift Cards and Gift Certificates, and (9) Manage a Loyalty Program . Each lesson has four parts: 1) learning objectives, 2) general discussion, 3) multiple task demonstrations, and 4) review questions.
Learn about the vast content management capabilities of Connected Business eCommerce.
This course shows the Solution Provider where to access support materials, how to get support, and where within Connected Business to market their products and services.
This course, Managing Your Finances, covers the Banking and Accounting Modules in Connected Business.
The Sales and Customer Service Course is designed to help the Connected Business user manage Leads, Prospects, and Customers. The processes taught support sales, customer service, and customer collections.
Awarded To:
David Nelson
Certificate ID: 101
Course name: Solution Provider Support, Resources, & Marketing
Completion Date: 2018-03-09
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 102
Course name: Solution Provider Sales Program
Completion Date: 2018-03-10
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 103
Course name: Presentation/Demonstration
Completion Date: 2018-03-11
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 155
Course name: Supporting Customers
Completion Date: 2018-12-30
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 156
Course name: Sales and Customer Service
Completion Date: 2019-01-06
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 150
Course name: Managing Your Shopping Cart from the Back Office
Completion Date: 2019-01-06
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 153
Course name: Manage Your Inventory
Completion Date: 2019-01-06
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 151
Course name: Skin Design
Completion Date: 2019-01-06
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 149
Course name: Managing Your Finances
Completion Date: 2019-01-06
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher:
Awarded To:
David Nelson
Certificate ID: 154
Course name: Implementation And Setup (Free)
Completion Date: 2018-12-21
Site name: Connected Business Community
Site URL: https://mycb.university/
Teacher: